View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
 
Posts: 492
Default VLOOKUP not working???

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