vlookup issue
vlookup issue
(OP)
Hi
I have a sheet with a vlookup which I cannot get to work. In the Vlookup tab column C I want it to bring the information in the data tab column c where column A in both sheets match.
But I am getting #N/A for all of the results. I have googled how to the vlookup so I think I have it right but could be wrong of course.
I have attached an example of the sheet
Thanks in advance for any assistance.
I have a sheet with a vlookup which I cannot get to work. In the Vlookup tab column C I want it to bring the information in the data tab column c where column A in both sheets match.
But I am getting #N/A for all of the results. I have googled how to the vlookup so I think I have it right but could be wrong of course.
I have attached an example of the sheet
Thanks in advance for any assistance.
RE: vlookup issue
combo
RE: vlookup issue
C1: =VLOOKUP(TEXT(A1,"0000"),Data!A:C,3,FALSE)
...COPY N PASTE down.
FYI: FAQ68-6659: When is a NUMBER not a NUMBER?
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
RE: vlookup issue
Thanks as always
RE: vlookup issue
combo