Vlookup across Files

[jae113]

Hello All,

I have a lookup table on File 2, "Manager" that has two columns, description(SG Mngr & Desc) and SG Mngr Name.
I would like to search in File 1, column E, and if the description matches what is in File 2, return the name in File 1, column G.

I'm having a hard time with it, but this is what I have so far. I started in G246:

=VLOOKUP(E246,'[Manager.xlsx]SG Mngr & Desc'!$A2:$A150,2,FALSE)

The description has to be exact so I used False.
The names are in the second column in File 2 "Manager", so I put 2.
I want it to search File 2, "Manager", all of column A (the descriptions) so that is the range.
And I want it to compare the range to the data in E246.

I don't understand VLOOKUP well enough to sort out what I'm doing wrong. I know I'm not telling it to do what I want it to do, but I don't know at which step I went wrong.

Any and all help very much appreciated!

 

[rdw72777]

You should be getting an error. Your data range only has one column $a$2:$a$150. But you want it to look at the second column. Maybe $A$2:$A$150 should be $A$2:$B$150 ?

 

[jae113]

Perfect! thank you so, so much!