W1-A | 1 | 1 | Apples |
W1-A | 1 | 2 | Strawberries |
W1-A | 1 | 3 | Raspberries |
<tbody>
</tbody>
W1-A | 1 | 1 | Apples |
W1-A | 2 | 1 | Pears |
W1-A | 3 | 1 | Bananas |
W1-A | 1 | 2 | Strawberries |
W1-A | 1 | 3 | Raspberries |
W1-A | 3 | 2 | Kiwi |
W1-A | 4 | 1 | Oranges |
W1-A | 5 | 1 | Clementines |
W1-A | 6 | 1 | Satsumas |
<tbody>
</tbody>
I am trying to create a formula for the first table to be placed in column 4, that can look at it's 3 values to the left in columns A, B and C and find a match in the 2nd table. In this example, Table 1, A4 would return 'Apples' as it immediately finds a match for 'W1-A', '1' & '1' in the 1st row of Table 2. The 2nd row of Table 1 returns Strawberries as it finds it's matches in Row 4 of Table 2.
I am getting odd results using an INDEX & SUMPRODUCT functions. Can anyone help?
P.S. My table may not start in row 1 of the spreadsheet
Last edited: