Forum Discussion

Gkerr's avatar
Gkerr
Copper Contributor
Aug 26, 2022
Solved

Index Match help - #Value error

Hi, I am looking for some help with the below:   In cell D9, I am looking to return the % value in the table at the bottom of the screen shot. I want cell D9 to say find me the % value in the table...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Aug 26, 2022

    Gkerr That could be:

     

    =INDEX(C16:N25,MATCH(L9,B16:B25,0),MATCH(M9,C15:N15,0))

    Not sure why you would want to involve D6.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 26, 2022

Gkerr That could be:

 

=INDEX(C16:N25,MATCH(L9,B16:B25,0),MATCH(M9,C15:N15,0))

Not sure why you would want to involve D6.

 

Gkerr's avatar
Gkerr
Copper Contributor
Aug 26, 2022
Thank you so much. The Involvement of D6 is so that when I move to cell F9 the formula is then taking the % rate for the date in F6 etc.