I am trying to perform a VLOOKUP on a spreadsheet referencing a table array on another spreadsheet. Some, but not all, values are coming up as #NA. There are no invisible or hidden characters, and I checked most of the values, and they are in fact on the table array I am having the VLOOKUP search. I am completely at a loss.

Here is my formula:

=VLOOKUP(M2,'S:\FY 2012 ACTIVITY\FY12 Outstanding 2237s\[Status Tech.xls]Status Tech'!$A$2:$B$903,1)

Like I said, it finds many, but many more are coming back as #NA.

Also, the formatting is the same for all coolumns. They are all formatted for text.

I have included the two spreadasheets I am working from. Someone, please help.

The columns in question are:
(From the March 19 sheet) M and O
(From the status Tech Sheet) A and B

I want the formula to search the staus Tech sheet and return a value into the O column, searching for the M Value. Thanks.

Brian

Edit:

Solved this on my own, thanks.