Bob:
I am trying to compare column B in worksheet called "Data" to the data
on worksheet called "Tier 1" using column E and column F.
Part of the information is being pulled over but I have about 25% that
comes up NA.

"Bob Phillips" wrote:

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!