Hello all,

I have spent half day to determine on how to set the following formula but
turn out i got nothing

In Excel, I have product name in one spreadsheet

Product Name ( spreadsheet 1)
cell (A1)
ABC
EDF
JIG
KAG
LNN
POR

Spreadsheet 2, I have customer name about 2200 rows:-

Cell (A1) Cell (B1)
Customer name Product name
A EDF
A JIG
A KAG
A LNN
B JIG
B KAG
B LNN
B POR

How to set a formula tin Cell A3 to determine Customer A haven't buy product
'ABC" & "POR" and Customer B haven't buy product 'ABC" & "EDF"

In some situation, customer may bought all the 6 products.

thanks.