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

ibddude

New Member
Joined
Aug 20, 2011
Messages
17
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
Maybe

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

M.
 

ibddude

New Member
Joined
Aug 20, 2011
Messages
17
Awesome!, that seems to work. I tried the INDIRECT function but I didn't have the syntax correct. Thanks a bunch!:biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,095,395
Messages
5,444,225
Members
405,274
Latest member
go2nivas

This Week's Hot Topics

Top