VLOOKUP returning #N/A and some values that are wrong

[ksmith21]

I just have no idea what I am doing wrong.

I have two worksheets and 4 VLOOKUP formulas on one of them for each row. For some reason the VLOOKUP is not finding the corresponding value on the other worksheet even thought when you do a ctrl + F it finds it.

What makes it more odd is about half way down the VLOOKUP formulas they start populating data but it is so very wrong.

Worksheet1: 'GLOBAL NAV STRUCTURE' - Data from A2:E1606 not including headings
Worksheet2: 'Export from Pyxis' - Lookup value in column B. VLOOKUP formulas in columns K to N.
Formula in K2 =VLOOKUP($B2,'GLOBAL NAV STRUCTURE'!$A$2:$E$1606,1).

I want to return the value in column A of the Global Nav Structure worksheet into cell K2 of the 'Export from Pyxis' worksheet but it is just coming up with #n/a.

Alternatively, when I get down to cell K546 in the 'Export from Pyxis' worksheet the VLOOKUP formula starts showing me values but they aren't the right ones by a long shot.
Formula in K546 in the 'Export from Pyxis' worksheet =VLOOKUP($B546,'GLOBAL NAV STRUCTURE'!$A$2:$E$1606,1)

Any help would be appreciated.

Thanks

 

[arthurbr]

By omitting the last argument you return an approximate match. For exact matches you should add ,0 or , FALSE at the end
Why are you looking up your trying to return a value in the first column of the range when you already have that value?(B2)
Your formula should look like =VLOOKUP($B2,'GLOBAL NAV STRUCTURE'!$A$2:$E$1606,XXX,0) where XXX is the number of the column you want to retrieve a value from in the range A2:E1606