Thread: Using Value of a Cell in the Range Reference in VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yangtze Yangtze is offline
external usenet poster
  
Posts: 1
Default Using Value of a Cell in the Range Reference in VLOOKUP
I am trying to use the value of cell to be the reference to a named range in
a VLOOKUP function:

=VLOOKUP(Value,$A$2,A1,false)

in cell A2 would be entered the named range value, i.e., "Data"

I know that I can use references for the lookup and the offset values. Any
ideas? Can I automate VLOOKUP with this much flexibility?
Reply With QuoteReply With Quote