Excell Lookup formula question, 2 criteria
 

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%

Excell Lookup formula question, 2 criteria
 

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

=INDEX(B2:D6,MATCH(H1,A2:A6,0),MATCH(H2,B1:D1,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MrsRose" wrote:

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%

Excell Lookup formula question, 2 criteria
 

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

"Luke M" wrote:

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

=INDEX(B2:D6,MATCH(H1,A2:A6,0),MATCH(H2,B1:D1,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MrsRose" wrote:

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%