There are no formulas....they are simply names and i need to lookup the
process they are working for. thats it......and its not that A1 is not
there..it is there. even if i drag it down...it shows NA in all the cells...

and theres one new thing i just discovered. I am trying to lookup A1...the
name in A1 was copied from an email body.....now if i type the same name in
A1, it gives me the result.....but i can not type it....tahts why i ma using
VLOOKUP. its weird...am seeing it for the first time.
please help

"Alan" wrote in message
...
There's nothing wrong with the formula, it must be either in the lookup
range or what is in A1. Are the values you're searching the results of
formulas? If so it may well be a rounding issue,
Regards,
Alan.
"Gary" wrote in message
...
Hi All....

Okay.....I dont know WHY this formula is giving me #N/A.

=VLOOKUP(A1,Sheet2!$T$2:$U$259,2,FALSE)

I do not see anything wrong with this formula....what could cause this???

Thanks in advance
Gary