Indirect function

[Graemea]

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!

 

[Domenic]

Try...

INDIRECT("'"&C2&"'!"&F3&":"&G3)

Hope this helps!

 

[Graemea]

Excellent, thanks very much!

 

[Domenic]

You're very welcome!

Cheers!