Formula - vlookup

[Roses8]

Hi, Im trying to do a vlookp but with wrong results.

look up the value in B2 and match in column B in sheet 2, if they match then take the name from Column A in the same row should be the result.

=VLOOKUP(B2,Sheet2!A:B,2,1)

Thanks.

 

[Von Pookie]

For VLOOKUP to work, the value you are searching for needs to be in the left column of the table you are searching. It will not work if you are searching column B and trying to return a value to the left of it.

 

[Roses8]

Hi, I changed that but its still not working.

 

[NBVC]

Try changing the 1 to FALSE. Does that work?

 

[Aladin Akyurek]

Hi, Im trying to do a vlookp but with wrong results.

look up the value in B2 and match in column B in sheet 2, if they match then take the name from Column A in the same row should be the result.

=VLOOKUP(B2,Sheet2!A:B,2,1)

Thanks.

If Sheet2!A:B is sorted on column B in ascending order and maintained in that order...

=LOOKUP(B2,Sheet2!B:B,Sheet2!A:A)

If not sorted...

=INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0))

 

[Roses8]

Hey, Thank you that worked. I sorted the columns and the results are spot on!.