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,
|