hlookup with the sheet name is a reference from another cell


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

Advertisements

I

isabelle

hi Patrick,

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

isabelle

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

Advertisements

3

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top