Can someone please help me with a formula to do the following? I can't find any previous solutions.
If a value from column A, features in any value in column C as the 3rd and 4th value, return the value from column B corresponding to the value in column A. Results being returned in column D.
<tbody>
</tbody>
If a value from column A, features in any value in column C as the 3rd and 4th value, return the value from column B corresponding to the value in column A. Results being returned in column D.
Column A | Column B | Column C | Column D |
AB | Apples | 12XY9009 | |
XY | Bananas | 35AB1221 | |
DX | Pears | 96AB9875 | |
FR | Oranges | 89DX6854 |
<tbody>
</tbody>