Help with Table arrays in HLOOKUP FUNCTION

[lindsayclaire]

Hi guys!

I need help with the HLOOKUP function. I've attached an example of what I'm working with.

Basically - I want to populate the table and I need to use the HLOOKUP function to do so.
The Tables I refer to below are tables I have named elsewhere in my workbook.

If the HLOOKUP function is in the row labelled 11 I want to use Table11 as my array.
If it is in the row labelled 12 I want to use Table12 as my array.
If it is in the row labeled A I want to use TableA as my array.

I know I could manually type in the Table names but my final matrix is huge and I cannot do this for every row.
Basically I want to figure out a way that I can write my table array as Table-"name of row"- and then use the autofill to complete the matrix for me

HELP!!

excel help.png

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[lindsayclaire]

Hi! Thanks so much for a prompt reply. I have uploaded an example workbook

[JohnTopley]

In B8

=IFERROR(HLOOKUP(B$7,INDIRECT("TABLE" &$A8),2,FALSE),"")

Copy across and down

[lindsayclaire]

Wow thanks!!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[shukla.ankur281190]

Or Try

B8

Please Login or Register  to view this content.