Index Match formula I am trying to use the index formula to lookup a value in a

Question

Index Match formula

I am trying to use the index formula to lookup a value in a range name. I started simple with =index(indirect($A2,3,10). Now I need to replace the row and column numbers with something dynamic.

The number I'm looking for will always be in a range name (for example MEYERL). The row will always be looking for a month (Jan, Feb, etc) and the column will always be looking for the word BONUS.

In other words; I want to look at the range name MEYERL and find cell than goes with the row month January and column Bonus.

I included a screenshot. A1:D7 would be range name MEYERL. A9:C13 would be range name JORDANC.

My formula would be in cell B16. I want to find the information in the name range listed in A16 for row of B15(January) x column = "Bonus"

I really appreciate any help you can give me. Thank you in advance.

Thanks !!

Explanation / Answer

Hi..

try this

In B16:

=INDEX(INDIRECT($A16), MATCH(B$15, INDEX(INDIRECT($A16), 0, 1), 0), MATCH("Bonus", INDEX(INDIRECT($A16), 1, 0), 0))

This formula can be filled to the right (and down, if desired).

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects