Hey Niek,

Whats the syntax for clean or trim? is it =CLEAN(A1) OR =TRIM(A1)? if yes,
its not working.

"Niek Otten" wrote in message
...
Hi Gary,

There may be invisible characters or spaces in your search argument. Use
the CLEAN() and/or the TRIM() function and if that
doesn't help, use David McRitchies TrimAll function:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Gary" wrote in message
...
| 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
|
|
|
|