G
Guest
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
=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