I need a formula that returns a value from columns C-F based on 2 criteria in columns A & B.
So an example using the below;
Bravo, Item 3 - should return 6,8,5,6 when I drag the formula across
I think its index match but unsure :-/
TIA
So an example using the below;
Bravo, Item 3 - should return 6,8,5,6 when I drag the formula across
I think its index match but unsure :-/
TIA
A | B | C | D | E | F | |
1 | Alpha | Item 1 | 1 | 3 | 4 | 9 |
2 | Item 2 | 2 | 1 | 1 | 4 | |
3 | Item 3 | 8 | 2 | 8 | 8 | |
4 | Item 4 | 3 | 1 | 2 | 3 | |
5 | ||||||
6 | Bravo | Item 1 | 4 | 1 | 1 | 4 |
7 | Item 2 | 8 | 2 | 8 | 8 | |
8 | Item 3 | 6 | 8 | 5 | 6 | |
9 | Item 4 | 3 | 1 | 2 | 3 | |
10 | ||||||
11 | Charlie | Item 1 | 1 | 4 | 4 | 1 |
12 | Item 2 | 8 | 8 | 1 | 8 | |
13 | Item 3 | 5 | 6 | 8 | 5 | |
14 | Item 4 | 2 | 3 | 2 | 2 |