smim
2015-10-11 02:07:34 UTC
Vlookup formula =VLOOKUP(A3,DATA2!A1:B19,1,0) does not return correc
information.
I am searching for a numeric code from sheet one in sheet 2 to display
separate numeric code back into sheet 1.
What happens is it returns information from a different row, when I pu
false it says #NA.
I've tried to change the type of format and sorting it but I'm at
loss.
Thanks for your help.
cris
+-------------------------------------------------------------------
|Filename: sheet1.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1018
|Filename: sheet2.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1019
+-------------------------------------------------------------------
--
smim
information.
I am searching for a numeric code from sheet one in sheet 2 to display
separate numeric code back into sheet 1.
What happens is it returns information from a different row, when I pu
false it says #NA.
I've tried to change the type of format and sorting it but I'm at
loss.
Thanks for your help.
cris
+-------------------------------------------------------------------
|Filename: sheet1.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1018
|Filename: sheet2.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1019
+-------------------------------------------------------------------
--
smim