hlookup with the sheet name is a reference from another cell

  • Thread starter Thread starter 3Suk
  • Start date Start date
3

3Suk

Dear all,
I have below formula, I would like to have the sheet name "2015" can be dynamically changed with reference to another cell, say A1. Any function can do this?

Thanks for your help in advance.

=HLOOKUP(B$1,'2015'!$B$1:$F$33,33,FALSE)

Regards,
Patrick.
 
hi Patrick,

=HLOOKUP(B$1,INDIRECT("'"&A1&"'!$B$1:$F$33"),33,FALSE)

isabelle

Le 2015-01-25 22:07, 3Suk a écrit :
 
Back
Top