I am trying to extract data where I search for a specific test string in a column list and return a value from a corresponding column list. There are multiple instances of the specific text and I need the values to all of them. For example:
Mini-sheets are cool!
FORMULA | ||
NAME | VALUE | RESULT |
A | 1 | 1 |
B | 2 | |
C | 3 | |
A | 4 | 4 |
E | 5 | |
F | 6 | |
A | 7 | 7 |
F | 8 | |
A | 9 | 9 |
A | 10 | 10 |
Mini-sheets are cool!