Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returning NA when referencing cell data to another sheet
Okay so I am using the following formula;
=VLOOKUP(A97, Sheet1!A1:D1775, 2, FALSE) Cell A97 contains a part number, in this instance CM-150. Sheet1 Cells A1:D1775 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!A1:D1775, 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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returning NA when referencing cell data to another sheet
Try re-entering CM-150 in cell A97. As is, cell A97 might contain unseen
leading/trailing whitespace characters. -- Biff Microsoft Excel MVP "Giacomo" wrote in message ... Okay so I am using the following formula; =VLOOKUP(A97, Sheet1!A1:D1775, 2, FALSE) Cell A97 contains a part number, in this instance CM-150. Sheet1 Cells A1:D1775 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!A1:D1775, 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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returning NA when referencing cell data to another she
Yeah that was totally it. I feel really inept right now.
Thanks for that mate! Giacomo "T. Valko" wrote: Try re-entering CM-150 in cell A97. As is, cell A97 might contain unseen leading/trailing whitespace characters. -- Biff Microsoft Excel MVP "Giacomo" wrote in message ... Okay so I am using the following formula; =VLOOKUP(A97, Sheet1!A1:D1775, 2, FALSE) Cell A97 contains a part number, in this instance CM-150. Sheet1 Cells A1:D1775 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!A1:D1775, 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!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup returning NA when referencing cell data to another she
I feel really inept right now.
I get that feeling at least once a day! It's no big deal. Thanks for the feedback! -- Biff Microsoft Excel MVP "Giacomo" wrote in message ... Yeah that was totally it. I feel really inept right now. Thanks for that mate! Giacomo "T. Valko" wrote: Try re-entering CM-150 in cell A97. As is, cell A97 might contain unseen leading/trailing whitespace characters. -- Biff Microsoft Excel MVP "Giacomo" wrote in message ... Okay so I am using the following formula; =VLOOKUP(A97, Sheet1!A1:D1775, 2, FALSE) Cell A97 contains a part number, in this instance CM-150. Sheet1 Cells A1:D1775 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!A1:D1775, 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using data in cell for sheet referencing in formulas | Excel Discussion (Misc queries) | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
Vlookup returning No data. | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) |