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.
Probably her use Vlookup (NumberValue(A2), Table_array, Col Index ,0)
Assuming the value in the table is a number
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.