Index,Match VLOOKUP Question

[jajones4043]

Here is my data...

	A	B	C	D	E
	Indiv Avg Rating	1	2	3
1	2.00	1.00%	1.00%	1.00%
2	2.25	1.18%	1.25%	1.30%
3	2.50	1.36%	1.49%	1.60%
4	2.75	1.55%	1.74%	1.90%
5	3.00	1.73%	1.98%	2.20%

<tbody>
</tbody>

Cell a10=2.8 (Rating) And Cell A11=2 (Tier Level 1, 2 or 3)

I need to create formula in cell E1 that will pull corresponding value from my chart. In this case with a rating of 2.8 and a Tier level of 2 I would want it to pull 1.74% because 2.8 is less than the next rating level of 3.00 in Column A. If rating was 3.00 in cell a10 I would want it to pull 1.98% and so on. I'm sure this can be accomplished by Vlookup, INdex and maybe match but is that the easiest way and if so what would it be?

 

[DRSteele]

This outta do it:

E1: =INDEX($B$2:$D$6,MATCH(A10,$A$2:$A$6,1),MATCH(A11,$B$1:$D$1,0))

Your data is skewed: for this formula, 1.74% resides in cell C5

 

[jajones4043]

Thanks so much. It worked perfectly!

This outta do it:

E1: =INDEX($B$2:$D$6,MATCH(A10,$A$2:$A$6,1),MATCH(A11,$B$1:$D$1,0))

Your data is skewed: for this formula, 1.74% resides in cell C5

 

[DRSteele]

Super. You're welcome.