Hi,

Am Tue, 2 Aug 2016 05:50:44 -0700 (PDT) schrieb Munster:

I need the result be the location of APPLES AP16063

if the Product Date is a unique value try:
=INDEX(E7:E1000,MATCH(B2,C7:C1000,0))
Else try:
=INDEX(E7:E1000,MATCH(A2&B2,A7:A1000&C7:C1000,0))
The last formula is an array formula to be entered with
CTRL+Shift+Enter.


Regards
Claus B.
--
Windows10
Office 2016