Forum Discussion
Solved
vlookup #N/A issues - not a 'newbie'
I am struggling with a persisitant #N/A message. Formula is this: =VLOOKUP(D6,'[Clients.xlsb]Jobs-Orders'!$A$3:$Y$10000,7,FALSE) I have checked the following: D6 refers to the correct cell for th...
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.
I have tried again with the following formula, copied and pasted from another sheet in the same workbook, where the vlookup is working OK, and bringing up the exact same required data. Grrrr!!!!
=VLOOKUP(B1,'\\DOMINIC-PC\Documents\user-files\Documents\SUNNVENT\Clients\[Clients.xlsb]Jobs-Orders'!$A$3:$Y$10000,7,FALSE)
=VLOOKUP(B1,'\\DOMINIC-PC\Documents\user-files\Documents\SUNNVENT\Clients\[Clients.xlsb]Jobs-Orders'!$A$3:$Y$10000,7,FALSE)