IF with 2 Criteria

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I think I need an IF AND...

I have a table of data that has 2 columns of data. Col A
has a list of customers and Col B has a list of products.
The "pair" for example A1 and B1 tell me that customer in
A1 purchased the product in B1.

Next I have a list of Customer-Product Pairs. I would like
to create a formula that will look at each of my customer
pairs (say in cells d1 and e1) and return "true" if the
pair exists on the table of data.

thank you in advance for your help.
 
Hi
one way: Try the following array formula - entered with
cTRL+SHIFT+ENTER):
=IF(ISNUMBER(MATCH(1,(A1:A100=D1)*(B1:B100=E1),0)),TRUE,FALSE)
 
Back
Top