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!! |
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) |