Using Index Match Function for a combination of 3 criteria

[questforexcel]

Hello All,

My Apologies, I cannot use the template used on your site to visually explain and show the calculations, cause all external files are disabled on my pc.

I've used index match functions previously based on two specific criteria i.e. a specific row value and a specific column value.

Is there a way to draw an index match function using 3 criteria. Here is what I need - compare full year month by month values (Criteria 1) for different products based (Criteria 2) on the Actual and Budget values (Criteria 3) . I am trying to find a way to add the scenario for Actual / Budget values.

Previously, I had to manually change the index match range cells to different columns for the actual and budget values.

Is there a way I could combine these into one formula to ease the work and reduce potential for error.

Thank you,

 

[GlennUK]

Post screen-shots or copies of your data, and what you want to do.