I am trying to get a formula to look up a range
I am using the formula SUMIF the first part is to select the range. I am trying to use the formula MATCH to get the range. I can find the row number ie 12 but not sure how to put in a range of 12:12 into the SUMIF Formula Please Help
If I use the ADDRESS FORMULA I can get it to set the range as $A$12
ADDRESS(MATCH(C1,A1:A17,0),1)
I am using the formula SUMIF the first part is to select the range. I am trying to use the formula MATCH to get the range. I can find the row number ie 12 but not sure how to put in a range of 12:12 into the SUMIF Formula Please Help
If I use the ADDRESS FORMULA I can get it to set the range as $A$12
ADDRESS(MATCH(C1,A1:A17,0),1)
Book5 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 010007 | |||||||
2 | ||||||||
3 | P025292/2 | PLASMAPART08.0MM | ||||||
4 | P025293/2 | PLASMAPART08.0MM | ||||||
5 | P010007/2 | PLASMAPART08.0MM | 1 | COUNTIF(12:12,A5) | 12 | MATCH(C1,A1:A17,0) | ||
6 | P013489/2 | PLASMAPART08.0MM | ||||||
7 | P013715/7 | PLASMAPART08.0MM | ||||||
8 | P013781/2 | PLASMAPART08.0MM | ||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | 010007 | P010007/1 | P010007/2 | 011032 | ||||
13 | 010229 | P010229/1 | R1200 | |||||
14 | 010245 | R1056 | ||||||
15 | 010249 | P010249 | ||||||
16 | 010275 | P010275 | 011011 | |||||
17 | 010297 | P010297 | ||||||
18 | ||||||||
Sheet1 |