hlookup with the sheet name is a reference from another cell

[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.

 

[isabelle]

hi Patrick,

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

isabelle

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

 

[3Suk]

hi Patrick,

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

isabelle

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

isabelle,
it works, thanks so much.

Patrick.