Using a cell string as sheet reference

[OneLooseCrank]

Hi all,
I currently have:
=VLOOKUP($A3,'9X'!$A$5:$Q$35,11,FALSE)
Where the sheet name is [9x]. I would like to change this to the contents of a cell - logically (or not as it seems) I thought I would try:
=VLOOKUP($A3,'(D3)'!$A$5:$Q$35,11,FALSE)
where it should pull the contents of D3 to fill the quotation marks and thus complete the sheet reference. It doesn't work like that however! Any thoughts?
Thanks,
OLC

 

[Joe4]

Whenever build a range dynamically, you need to use the INDIRECT function to convert the string you are building to a range.
Try:

=VLOOKUP($A3,INDIRECT("'" & D3 & "'!$A$5:$Q$35"),11,FALSE)

 

[OneLooseCrank]

Whenever build a range dynamically, you need to use the INDIRECT function to convert the string you are building to a range.
Try:

=VLOOKUP($A3,INDIRECT("'" & D3 & "'!$A$5:$Q$35"),11,FALSE)

Stunning That's just done a cracking job for 300 records - all now getting their sheet reference without me typing the thing repeatedly!