Hello folks, thank you for looking after this forum - newbie here, long time Excel user and now trying to tap into the full power it offers.

My raw data is a matrix
Y axis = "Years of service" (split into two cells as there are spreads e.g.0-3, 3-5, 5-7 etc.)
X Axis = "Age"

I am trying to multiply a wage by the result from the matrix based on the person's Years of Service and Age. Hope this makes sense. I tried using an IF formula - with some other formulas thrown in (to be honest created a bit of a monster) is there an easier way to do this?

I cannot attach an item to this and cannot post the formula directly in here either

Your assistance is greatly appreciated