Forum Discussion
vlookup #N/A issues - not a 'newbie'
Dominic_Joslin The A500 in my formula was just an example. Find the actual cell reference of the value that should match what is in cell D6 (the lookup_value in the VLOOKUP function). Let's say that actual reference is A235, then somewhere else type =D6=A235. If the result is FALSE, you know for sure that the two values are NOT the same.
By the way, I saw you post on Myonlinetraininghub where you asked the same question and where you received more or less the same answer.
Dominic_Joslin VLOOKUP returning an #N/A error means that it did NOT find a match. Are you sure that the numbers 333 are the same in both lists? What do you get when you enter a formula like
=D6='[Clients.xlsb]Jobs-Orders'!$A$500
where A500 in the Clients file also contains the 333 you are trying to match. Change that reference to the one that really contains 333. Do your get TRUE or FALSE?
If FALSE, then both "numbers" are not the same. One might have been entered(imported) as text. Reformatting the cell/column to Number or General will not automatically transform a text from, for instance " 333 " (note the leading/trailing spaces) to a number 333.
Riny_van_Eekelen Thank you for replying.
I have just checked the 333 numbers, and in both places lookup_value, and table_array, they seem to be 'clean', IE no empty spaces before or after, and both formatted as numbers.
I tried to paste your suggested test formula, and twice, IE in two different cells it returns False. I tried it with both A500 and A333.
Curiously, when I try my formula in a cell on another Sheet in the Workbook, it works fine. ?? Could there be something up with the new sheet?
Dominic_Joslin The A500 in my formula was just an example. Find the actual cell reference of the value that should match what is in cell D6 (the lookup_value in the VLOOKUP function). Let's say that actual reference is A235, then somewhere else type =D6=A235. If the result is FALSE, you know for sure that the two values are NOT the same.
By the way, I saw you post on Myonlinetraininghub where you asked the same question and where you received more or less the same answer.
- Hi Riny. I just tried what you suggested, and the result was True. What I was doing before was entering the value of col/row A235 (for eg.), being 333 (IE: A333), rather than the proper cell reference. So your test indicates that the values are the same.
However, good news: the problem formula is now working correctly. I don't know exactly what action has fixed it, but I'm going to credit it to your input. So, thank you.
- Probably her use Vlookup (NumberValue(A2), Table_array, Col Index ,0)
Assuming the value in the table is a number- Hi Donald. I have just tried the formula with 0 instead of False as the [Range_Lookup], but it hasn't fixed it IE still #N/A.
