Hi,
I'm new to VLOOKUP formulas, and trying to get this to work.
=VLOOKUP($E4;Data;2;FALSE)
Capture.PNG
Basically, I want '[email protected]' to appear in F1, beside 'Mary 1023', and '[email protected]' to appear in F2, beside 'John'. I'm trying to get it to get a name from column E and look for a match in column J (doesn't have to be an exact match, as there are codes after some names in column E, although, a trim function would be handy to just get the names), and when a match is found, to put the corresponding value from column K (E-Mail Address) into the adjacent cell in column F. How do I do that?
All I'm getting is the actual formula in the cell, all the way down.
Thanks!
Bookmarks