excelvlookup

Invalid Cell Reference Error while vlookup?

  1. Need to look up values under column A of sheet1 and match it with values under Column A of sheet2.
  2. If matches , Return the corresponding value under column B of sheet1 as result .
  3. Display the result under column C of sheet 2.

I came up with below vlookup formula and apply it on column C of sheet 2 but it gives error Invalid Cell Reference Error

=VLOOKUP(Sheet1!A:A,A:A,Sheet1!B:B,FALSE)

Solution

  • In the column c of Sheet2 use this vlookup formula.For example in Sheet2, cell c2 if you paste this formula. =VLOOKUP(A2,Sheet1!A:B,2,FALSE)

    The formula will look for the value in cell A2 of Sheet2 in Column A of sheet1 and return the corresponding value in columnB(exact match)of Sheet1 to Cell c2 in sheet2.

    Hope this helps!