Need Help With VLOOKUP Problem

[JeffK627]

Hi All,

I'm trying to use VLOOKUP to populate a column in one worksheet from another. Basically, I need the value in Sheet1 Column AA to be the same as the value in Sheet2 Column A that's in the same row as the value in Sheet2 Column B that matches a value in Sheet1 Column B. Here's what I tried:

=VLOOKUP(B4,Validation!$A$2:$B$14,1,FALSE)

This returns #N/A even though the value in Sheet1 Cell B4 is in Sheet2 Cell B8. Where have I gone wrong?

 

[wigi]

VLOOKUP works differently: the lookup value B4 is searched for in the leftmost column of the lookup range (columns A and B on sheet validation). So Excel looks in column A there, not column B.

 

[Jonmo1]

Vlookup can't work that way, It can only match a value in the Left column, and return a value from specified column TO THE RIGHT..
It's Zoolander challenged, can't go left..

You need Index/Match

=INDEX(Validation!$A$2:$A$14,MATCH(B4,Validation!$B$2:$B$14,0))


Hope that helps.

 

[JeffK627]

Thanks, jonmo1 - I wasn't aware of the INDEX/MATCH function. It worked perfectly.