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

Michelle wrote:

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