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 if L9 is found in B16:B25 and if M9 matches D6.

any help would be greatly appreciated.

Thank you

excel

Formulas and Functions

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.

3 Replies

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
  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.
  - Riny_van_Eekelen
    Platinum Contributor
    Aug 26, 2022
    Gkerr OK. Fair enough.

Forum Discussion

Index Match help - #Value error