creating a range reference from cell values
=VLOOKUP($K$16,INDIRECT(B17&"!A1:L32")3,FALSE)
"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
|