Thread: creating a range reference from cell values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robin Krupp Robin Krupp is offline
external usenet poster
  
Posts: 9
Default creating a range reference from cell values
I am try to do a vlookup where the range is built from cell values ex.

=VLOOKUP($K$16,TRIM(B17&"!"&"A1:L32"),3,FALSE)

b17 contains the sheet name

but gives me a #value! error

but works if the range is hard coded

But I really want to build the range dynamiclly

Can anyone help ???
thanks
Reply With QuoteReply With Quote