Hi,

It most probably means that the searched value (A2) is different type from
the ones in the first column of the lookup table ($A$2:$C$9216). You may
want to check if any values that appear like numbers are in reality text
strings or viceversa.

Regards,
KL


"canadian excel user" wrote in
message ...

I have used the following formula:
=VLOOKUP(A2,'[data aug15.xls]July 2005'!$A$2:$C$9216,2,TRUE)

I get N/A errors throughout the entire column.
Does anyone have any clue what I might be doing wrong?

Thanks very much,