creating a range reference from cell values
Try it like this:
=VLOOKUP($K$16,INDIRECT("'"&TRIM(B17)&"'!A1:L32"), 3,0)
--
Biff
Microsoft Excel MVP
"Robin Krupp" wrote in message
...
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
|