LinkBack URL
About LinkBacks
ypurcaro 
I used Vlookup all the time but I don't know what is wrong this time because it just doesn't work. When I type the employee id on cell D2 the employee name should pop up in cell E2. However, it gives me this #N/A error. Can you help please? Thanks.
I used Vlookup all the time but I don't know what is wrong this time because it just doesn't work. When I type the employee id on cell D2 the employee name should pop up in cell E2. However, it gives me this #N/A error. Can you help please? Thanks.
Is calculation set to manual?
Sorry, just read properly: I thought you were entering name in D2, and retrieving ID.
Vloookups work left to right, not right to left. Put id in col A, name in col B.
Last edited by Olly; 03-06-2014 at 08:01 PM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Wow...it works!! Thank you very much. I didn't know Vlookup is that sensitive.
or
=VLOOKUP(D2,CHOOSE({1,2},B2:B4,A2:A4),2,FALSE) or
=INDEX(A2:A4,MATCH(D2,B2:B4,0))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martindwilson,
Thanks for the suggestion. I've never used the Index but it seems pretty neat. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks