Results 1 to 5 of 5

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

  1. #1
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default

    What is the formula you have tried?

  3. #3
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Aladin,
    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.

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default

    Hi Aladin,
    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)

  5. #5
    Board Regular
    Join Date
    Jan 2007
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Thanks a million !!!!

    Regards,
    Nachiket Pendharkar.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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