Search code examples
excelworksheet-function

VLOOKUP Help with Ranges

I have the following VLOOKUP in a cell on sheet1.

=VLOOKUP(I2,Sheet2!B:C,2)

I assumed that this would attempt to return the corresponding value in column C on sheet 2 if it found a value in column B on sheet 2 that matched the value in I2 in sheet 1.

This doesn't seem to work though. Any ideas where I'm going wrong?

Solution

  • Think you need to add the 4th parameter - range_lookup. I always set this to FALSE.

    i.e. =VLOOKUP(I2,Sheet2!B:C,2,FALSE)