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.
Copy the data to another workbook
Or use XlookUp
Or use XlookUp
Do you mean copy the data in the sheet that I am trying to extract the data from, in this case the Clients workbook? Or the 'destination' workbook?
I have tried XLOOKUP, but didn't follow it all the way through, as the lookup_value is in the left most column of the sheet, so VLOOKUP seemed appropriate. I'll try it again, if nothing else sorts it out.
I have tried XLOOKUP, but didn't follow it all the way through, as the lookup_value is in the left most column of the sheet, so VLOOKUP seemed appropriate. I'll try it again, if nothing else sorts it out.