Excell Lookup formula question, 2 criteria

[MrsRose]

I must be missing something in my formula, please help! (Letters in column
A, header row 1)

Looking for formula to say if in Cell H1, "b", and Cell H2, "7", to return
15.20% Cell H3

Letter 1 6 7
a 2.00% 2.29% 2.00%
b 17.60% 15.25% 15.20%
c 17.70% 15.35% 15.30%
d 17.80% 15.45% 15.40%
e 17.90% 15.55% 15.50%

 

[Luke M]

You need to use the INDEX function. Assuming your table is in A16, the
formula is this:

=INDEX(B26,MATCH(H1,A2:A6,0),MATCH(H2,B11,0))

 

[MrsRose]

Thanks Luke! Some days I do not know where my head is. I was including my
header rows in my formula.