Hi,
I have a formula as follows:
INDIRECT(" ' "&C2&" '!$A$1:$B$30")
C2 holds sheet name to which I want the VLOOKUP in which this INDIRECT function is embedded to use.
Can someone please tell me how to amend the above formula so that the $A$1 and $B$30 can be referenced from adjacent cells e.g. F3 has A1 and G3 contains B30.
Thanks!
I have a formula as follows:
INDIRECT(" ' "&C2&" '!$A$1:$B$30")
C2 holds sheet name to which I want the VLOOKUP in which this INDIRECT function is embedded to use.
Can someone please tell me how to amend the above formula so that the $A$1 and $B$30 can be referenced from adjacent cells e.g. F3 has A1 and G3 contains B30.
Thanks!