using indirect in a formula

[tinkerbelle]

Hi everyone, I have the following formula in sheet "form"

=VLOOKUP(C6,op0607q1!$A$2:$BC$24851,$C$2,FALSE)

But want to change the reference 'op0607q1' to a =indirect function that will take whatever reference is in cell a1 of the sheet form and use the indirect formulae to lookup the sheet with the same name.

Thanks for anyones help.

[Bryan Hessey]

Hi everyone, I have the following formula in sheet "form"

=VLOOKUP(C6,op0607q1!$A$2:$BC$24851,$C$2,FALSE)

But want to change the reference 'op0607q1' to a =indirect function that will take whatever reference is in cell a1 of the sheet form and use the indirect formulae to lookup the sheet with the same name.

Thanks for anyones help.

Hi,

something like

=VLOOKUP(C6,INDIRECT(A1&"!$A$2:$BC$24851"),$C$2,FALSE)

should work.

hth
---

[tinkerbelle]

Thanks Bryan, that works perfectly!

[Bryan Hessey]

Thanks Bryan, that works perfectly!

good to see, and thanks for the feedback

---