creating a range reference from cell values
=VLOOKUP($K$16,indirect("'" & TRIM(B17) &"'!"&"A1:L32"),3,FALSE)
Are you sure you need the =trim() portion?
Robin Krupp wrote:
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
--
Dave Peterson
|