Vlookup value of #NA

[Guest]

Hi, I need help to setup the VLOOKUP function for a project, however, every
time I try to do it, it says, #NA.

I need to use VLOOKUP to pull in the costs for a list of products.

The costs are located in another file called ‘06 Standard Cost Data File –
M81’ and the data I need to pull in, is in A5:X272.

This is what I tried for VLOOKUP but got #N/A:

=VLOOKUP(A5,'[06 STANDARD COST DATA FILE - M81.xls]Std Cost
Data'!$A$5:$X$272,21,0)

Both files are sorted in ascending order and both files are in the same
format.

Can anybody help please???

 

[Dave Peterson]

Debra Dalgleish shares some troubleshooting tips here:
http://contextures.com/xlFunctions02.html#Trouble

Hi, I need help to setup the VLOOKUP function for a project, however, every
time I try to do it, it says, #NA.

I need to use VLOOKUP to pull in the costs for a list of products.

The costs are located in another file called ‘06 Standard Cost Data File –
M81’ and the data I need to pull in, is in A5:X272.

This is what I tried for VLOOKUP but got #N/A:

=VLOOKUP(A5,'[06 STANDARD COST DATA FILE - M81.xls]Std Cost
Data'!$A$5:$X$272,21,0)

Both files are sorted in ascending order and both files are in the same
format.

Can anybody help please???