A B C D E F G
1 PRODUCT PRODUCT DATE CODE LOCATION RESULT
2 APPLES AP16063
3
4
5
6 PRODUCT MFG Product Date COLOR LOCATION
7 APPLES TREE AP16057 YELLOW XX001A
8 ORANGE TREE OA16098 ORANGE XX002A
9 APPLES TREE AP16063 RED XX003A
10 CHERRIES TREE CH16075 RED XX004A


Formula needs to look up A2 and B2 from data and put the result into E3.
I have tried multiple times index/match combo as an array and non-array formula and no luck.

Any help would be appreciated. Sorry for the crudeness of a spreadsheet example.