Hi,

Am Mon, 1 Aug 2016 19:54:25 -0700 (PDT) schrieb Munster:

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.

what do you want to do? What is the expected result? Count of items?


Regards
Claus B.
--
Windows10
Office 2016