Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula Question | Excel Worksheet Functions | |||
SPECIAL LOOKUP FORMULA 4 MULTIPLE CRITERIA | Excel Discussion (Misc queries) | |||
Excell question about formula copying!!! | Excel Worksheet Functions | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Formula Question IF/Lookup???? | Excel Worksheet Functions |