ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Vlookup returning NA when referencing cell data to another sheet (https://www.excelbanter.com/excel-worksheet-functions/226216-vlookup-returning-na-when-referencing-cell-data-another-sheet.html)

Giacomo[_2_]

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



T. Valko

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





Giacomo[_2_]

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






T. Valko

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









All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com