View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mwam423 mwam423 is offline
external usenet poster
 
Posts: 103
Default VLOOKUP question

greetings everybody, am hoping to confirm something. i was using VLOOKUP, to
determine a range name for the range to search, inside a VLOOKUP. kept
getting #VALUE! and this is because VLOOKUP doesn't accept a formula as the
range to do the lookup on, is that correct? or am i getting this error for
another reason?