Hello,
I have been trying this for a long time now, and I just cannot get it to work.
=VLOOKUP(C89,A69:B83,1,FALSE)
I want to lookup the value in C89 in my range A:69:B8, and I want to return the first value in that range, i.e. from column A. However, it just doesn't work! It looks correct to me, but all I get is #N/A in my field.
Any ideas what I'm doing wrong?
Tia.
well this formula =VLOOKUP(C89,A69:B83,1,FALSE) is trying to find the value in C89 by looking at A69 through A83 and if it finds it there then it is returning the value itself, the B83 part is irrelevant to your formula. (EDIT) the whole reference to col B is irrelevant.
is it possible the value in C89 is slightly different than the value in A69 through A83 like a hidden space? Those would be the reasons it wouldn't work.
Last edited by Sam Capricci; 01-29-2015 at 01:41 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks