Dynamic change of worksheet reference in a Hlookup function

  • Thread starter Thread starter fariapedro
  • Start date Start date
F

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
 
Back
Top