Dynamic change of worksheet reference in a Hlookup function

[fariapedro]

Hi,

I am a basic user of MS Excel, and starting to use hlookup function.
In this function i have the worksheet reference that i want to change
linked with a cell in another worksheet.

The problem:
- HLOOKUP(Info!$D$10;'02545'!$A$1:$Z$219;70;FALSE),

- Want to change '02545' for the cell "Info!$D$11" which has th
worksheet reference, that i can change for another worksheet within th
workbook.

Thanks for the hel

 

[Guest]

Hi
=HLOOKUP(Info!$D$10;INDIRECT("'" & Info!$D$11 & "'!$A$1:$Z$219");70;FALSE),