Index Match formula I am trying to use the index formula to lookup a value in a
ID: 638881 • Letter: I
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 !!
Explanation / Answer
Hi..
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).