Excell Lookup formula question, 2 criteria

  • Thread starter Thread starter MrsRose
  • Start date Start date
M

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%
 
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))
 
Thanks Luke! Some days I do not know where my head is. I was including my
header rows in my formula.
 
Back
Top