• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hlookup - use indirect for Row index number

nadjalil

Member
Dear All
i have a problem to bring row index number from a different cell by indirect formula in Hlookup.
attached is an example of my file...

thanks to help me on this...

Kind Regards
 

Attachments

  • Hlook up with indirect for Row index.xlsx
    19.1 KB · Views: 8
Not sure, why you are trying to use an indirect function here..

The 3rd parameter of the HLookup function can be replaced with the cell address where you have used the indirect function.

Your current formula :

=HLOOKUP(B2,Details!$E$14:$E$28,INDIRECT(Sheet2!$A$3,0),FALSE)

Formula can be written as:

=HLOOKUP($B$2,Details!$E$14:$E$25,$A$3,0)

In the above formula, the cell $A$3 has been given as the 3rd parameter for HLookup function.

Please let me know, if I understood your requirement in a wrong way
 
Hi Nebu
my actual file has 1000 row index numbers and if i can divert it through a cell where i can give cell no i can save a lot of time to change almost 2000 formulas. i dont mind if you can give some thing simpler...

thanks for your help
 
Hi:

I understand that, do not wrap your cell a3 with indirect function you do not need indirect function to make your lookup dynamic just give a3 your Hlookup will work. I guess Ramesh has already explained it in one of the earlier post.

Thanks
 
Not sure, why you are trying to use an indirect function here..

The 3rd parameter of the HLookup function can be replaced with the cell address where you have used the indirect function.

Your current formula :

=HLOOKUP(B2,Details!$E$14:$E$28,INDIRECT(Sheet2!$A$3,0),FALSE)

Formula can be written as:

=HLOOKUP($B$2,Details!$E$14:$E$25,$A$3,0)

In the above formula, the cell $A$3 has been given as the 3rd parameter for HLookup function.

Please let me know, if I understood your requirement in a wrong way

Thanks Boss you understood my file and requirement correctily....
thanks for the inputs
 
Back
Top