Hi Gary,

The formula looks OK, but A1 seems not to be present in your list.
Maybe one is text and the other a number; you don't see the difference, but Excel does. Use the ISNUMBER and/or the ISTEXT
function to check.
Use the VALUE or the TEXT function to convert one type to the other.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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