Are you sure that the value in B2 is in column A of Tier 1? That is what
#N/A usually means, or that column E contains a #N/A.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mayoslc" wrote in message
...
We are trying to manipulate numbers using vlookup, approximately 4,300
records using the formula below:
=VLOOKUP(B2,'Tier 1'!A:A:'Tier 1'!E:E,5,FALSE)
There is one total property spreadsheet and 3 other tabs. About 1,500
records are coming back NA.
Any suggestions on what might be happening?? It looks like a formula
problem!