Thread: Vlookup Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
busboy10 busboy10 is offline
external usenet poster
 
Posts: 6
Default Vlookup Problem

Hi All,

I am dealing with a vlookup issue that i just can't figure out. I
have a vlookup statement that works fine, something to the extent of
vlookup(1.001, A1:C10, 9) for example. However, when i change 1.001
to a cell reference say C30 where C30 = 1.001, it doesn't work!!!!

i can't for the life of me figure out why not. the help says
referencing a cell for the lookup value should work fine.

Any thoughts?!?