=INDEX(OFFSET(A1,MATCH(15,A:A,FALSE),0):C10,MATCH(15,OFFSET(A1,MATCH(15,A:A,FALSE),0):A10,FALSE),2)
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | List | Value | Key | Last Value | 2nd value | |
2 | a | 1 | b | 10 | 6 | |
3 | b | 2 | ||||
4 | c | 3 | ||||
5 | d | 4 | ||||
6 | a | 5 | ||||
7 | b | 6 | ||||
8 | e | 7 | ||||
9 | f | 8 | ||||
10 | g | 9 | ||||
11 | b | 10 |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |