Can't get cell value to be sheet name for array value in HLOOKUP

[ibddude]

I have: =HLOOKUP(Table4[[#This Row],[parent_product_line]],UK_GBP!$B$11:$DK$65,4,FALSE)

What I want to do is have "UK_GBP!" be a valye which comes from another cell so I tried:

BE18 = UK_GBP

=HLOOKUP(Table4[[#This Row],[parent_product_line]],CONCATENATE(BE18,"!")$B$11:$DK$65,4,FALSE)

It errored out...any ideas on how I can accomplish this?

Thanks
MIke

 

[Marcelo Branco]

Maybe

=HLOOKUP(Table4[[#This Row],[parent_product_line]],INDIRECT("'"&BE18&"'!$B$11:$DK$65"),4,FALSE)

M.

 

[ibddude]

Awesome!, that seems to work. I tried the INDIRECT function but I didn't have the syntax correct. Thanks a bunch!

 

[Marcelo Branco]

You are welcome and thank you for the feedback

M.