Dear, I hope you can help me with the following query. I am performing a search in the matrix located in the range A2:G481 to bring me the values corresponding to the columns F and G, according to the criteria of Age (B:B), Year ($I$2) and Percentage according to gender (Male [F:F] and Female [G:G]). In columns L, M and N I have already made a calculation as I am looking for it, applying the SUMIFS function and it has given result. Now I want to replicate the same calculation but this time using the INDEX and MATCH function, for which I have done it in columns Q, R and S. For the male percentage, the calculations return the expected result, but when I try to apply the same function this time for the female percentage, I get #REF!
I hope you can tell me where I am making the mistake or if a simpler procedure using INDEX and MATCH can be applied.
Thank you for your attention.
Bookmarks