# Thread: Hlookup table array problem Thanks: 0 Likes: 0

1. ## Hlookup table array problem

Hi all,
I have got a worksheet whose Column C contains diffferent cell ranges. Column H contains an hlookup throughout. Now for all Column H entries, I am trying to enter the arguement "table array" of the hlookup as corresponding column C entry. However, I am getting all results as #N/A since the table array which is getting defined is nothing but the correspoding cell in Column C.

For eg. my cell C2 contains I4:I50. When I try to define the table array of the hlookup in H2 as C2(i.e. I want I4:I50 to feature in the hlookup formula) I get #N/A since the table array which is getting defined is nothing but C2.

So is there any solution for the above problem?

Any kind of help from you will be highly appreciated !!!

Regards,
Nachiket Pendharkar.

2. What is the formula you have tried?

I tried this formula in cell H2

=HLOOKUP(E2,C2,DAY('DR 2'!\$D\$4)+1,0)

Cell C2 contains I4:I50. Rest all arguements are working fine only table array is giving me trouble.

Hope you have a magic lamp for me(hehehehehe)

Regards,
Nachiket Pendharkar.

I tried this formula in cell H2

=HLOOKUP(E2,C2,DAY('DR 2'!\$D\$4)+1,0)

Cell C2 contains I4:I50. Rest all arguements are working fine only table array is giving me trouble.

Hope you have a magic lamp for me(hehehehehe)

Regards,
Nachiket Pendharkar.
=HLOOKUP(E2,INDIRECT(\$C\$2),DAY('DR 2'!\$D\$4)+1,0)

The indirect function works just superbly !!! You indeed have a magic lamp for me !!!

Thanks a million !!!!

Regards,
Nachiket Pendharkar.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•