Index,Match VLOOKUP Question

[jajones4043]

Here is my data...[TABLE="width: 485"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Indiv Avg Rating[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]2.00[/TD]
[TD="align: right"]1.00%[/TD]
[TD="align: right"]1.00%[/TD]
[TD]1.00%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]2.25[/TD]
[TD="align: right"]1.18%[/TD]
[TD="align: right"]1.25%[/TD]
[TD]1.30%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]2.50[/TD]
[TD="align: right"]1.36%[/TD]
[TD="align: right"]1.49%[/TD]
[TD]1.60%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]2.75[/TD]
[TD="align: right"]1.55%[/TD]
[TD="align: right"]1.74%[/TD]
[TD]1.90%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]3.00[/TD]
[TD="align: right"]1.73%[/TD]
[TD="align: right"]1.98%[/TD]
[TD]2.20%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.