My lookup value is in the spreadsheet I am referencing. I've changed all fields to text and I still get #N/A.
My lookup value is in the spreadsheet I am referencing. I've changed all fields to text and I still get #N/A.
Try this formula:
=VLOOKUP(TEXT(A16,"0"),'[Values for Lookup Formula.xlsx]Sheet2'!$A:$B,2,FALSE)
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Now the formula =VLOOKUP(TEXT(A16,"0"),'[Values for Lookup Formula.xlsx]Sheet2'!$A:$B,2,FALSE) is sitting in the field. It returned no answer.
That's because "Text" formatting is carried over from previous cell/range. Select cell and change format to "General" and re-evaluate formula.
Thank you CK76, that did work. So for future reference. My fields need to be "General" when doing VLOOKUP? And if they are not I can use the "Text" Function to convert them?
Only when source (i.e. Lookup Range) has number stored as text. All other case, you can use simple cell reference.
Thank you.
You are welcome
If you are satisfied with the solution provided. Please mark the thread as solved, using thread tools found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks