G
Giacomo
Okay so I am using the following formula;
=VLOOKUP(A97, Sheet1!A11775, 2, FALSE)
Cell A97 contains a part number, in this instance CM-150.
Sheet1 Cells A11775 contain;
A=Part Numbers
B=Tarriff Codes
C=Weights
D=Countries
In this instance I have confirmed that CM-150 is on Sheet 1 in column A with
the corresponding data in Columns B-D.
However this function is returning #NA.
When I repalce the cell reference in =VLOOKUP(A97, Sheet1!A11775, 2,
FALSE) from A97 to "CM-150" the forumula returns the correct data.
Does anyone know why I cant get the reference to work?
Thanks in advnace for your help!!
=VLOOKUP(A97, Sheet1!A11775, 2, FALSE)
Cell A97 contains a part number, in this instance CM-150.
Sheet1 Cells A11775 contain;
A=Part Numbers
B=Tarriff Codes
C=Weights
D=Countries
In this instance I have confirmed that CM-150 is on Sheet 1 in column A with
the corresponding data in Columns B-D.
However this function is returning #NA.
When I repalce the cell reference in =VLOOKUP(A97, Sheet1!A11775, 2,
FALSE) from A97 to "CM-150" the forumula returns the correct data.
Does anyone know why I cant get the reference to work?
Thanks in advnace for your help!!