excel - Define column range as multiple values for INDEX function -

I need to compare an insurance premium with the age and salary of a person. My age limitations are at the top, and the wages limitations are there in the way of any way that a column / row can represent a category? (I.e. column b is 1-5 , c is 6-10 etc.)

I think that the use of INDEX and MATCH functions, but for every age, one column and one line for every salary will not be made.

You only have to show "lower bound" for each category and then form the third argument with 1 Use MATCH in the example, for example B1: E1 as 1,6,11,16, then in A2: A5 salary in 0, 10000, 20000, 30000 then use this formula

= INDEX (B $ 2: E $ 5, match (G2, A $ 2: A $ 5,1), match (H2, B $ 1: E $ 1, 1))

Where G2 and H2 have special salaries and age, respectively search for 13 and 23,000 seeks 13 with D1 And will receive the value in 23000 in A4 and 20000 D4

---

.... Yes, I know that there is no possibility of a salary of 23000 at the age of 13 years ......!