VLOOKUP Help with Ranges

0
votes

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?

2
excelworksheet-function
What does it do then - #N/A!? Check that you're looking up the same type of data too. Looking up a text-formatted number won't match a numerical cell, for example. - Widor

2 Answers

2
votes

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)

0
votes

With my Excel 2003 it is working, when I replace the "," by ";". Are there versions out there that exepts "," as divider between the parameters?

This is working for me:

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

If you want to have only exact matches then you should use

=VLOOKUP(I2;Sheet2!B:C;2;FALSE)