# Thread: Need To Match 2-3 Cells to Show A Result Thanks:  2 Post #5343922 (1)Post #5344199 (1) Likes:  2 Post #5343922 (1)Post #5344199 (1)

1. ## Need To Match 2-3 Cells to Show A Result

Hello, I'm hoping someone might be able to help me please.

I have a project that I am working on where our IT department needs a report that shows all of our companies and product numbers, but next to each product, they would like us to enter "sales exist" if it shows that the product has sales on the second sheet in the book. The first sheet looks as such with all of our company products listed:
 COMPANY NUMBER PRODUCT NUMBER 1 497 25 513 8 72

The second sheet has the exact same information, but only contains products that we have existing sales. They would like the first page to show "Sales Exists" in the third column, if both the Company Number and Product Number is listed on the second sheet (due to there being the same products existing between multiple companies and some do now have sales):

 COMPANY NUMBER PRODUCT NUMBER 1 497 Sales Exists 25 513 8 72 Sales Exists

I was trying VLookup, but couldn't get the formulat to work right, right now, I'm using this formula:

=IF(ISNA(MATCH(B2,WithSales!B\$2:\$B\$333,0)),"", "Sales Exist")

which does return the results I'm looking for... however because we have multiple companies that use product number 497 it states that sales exist across all companies, even though the second sheet states only company 01 shows sales for this product.

I know this is probably an easy fix. I've searched many pages and videos but I was unable to find anything that I could get to work. Would anyone be able to help me with this please? Thank-you very much!

2. ## Re: Need To Match 2-3 Cells to Show A Result

Here's one way.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Sheet2

 A B C 1 COMPANY NUMBER PRODUCT NUMBER 2 1 497 Sales Exists 3 25 513 Sales Exists 4 25 497 5 25 72 6 8 72 Sales Exists 7 8 497 Sales Exists

 Cell Formula C2 {=IF(ISNA(MATCH(A2&"/"&B2,Sheet1!\$A\$2:\$A\$5&"/"&Sheet1!\$B\$2:\$B\$5,0)),"","Sales Exists")}
Formula Array:
Produce enclosing
{ } by entering
formula with CTRL+SHIFT+ENTER!

Sheet1

 A B 1 COMPANY NUMBER PRODUCT NUMBER 2 1 497 3 25 513 4 8 72 5 8 497

Excel tables to the web >> Excel Jeanie HTML 4

3. ## Re: Need To Match 2-3 Cells to Show A Result

This worked perfectly! I can't thank-you enough for helping with this Thank-you again so much!

4. ## Re: Need To Match 2-3 Cells to Show A Result

Here is another way with a normal-entry formula

Sheet2

 A B C 1 COMPANY NUMBER PRODUCT NUMBER 2 1 497 Sales exist 3 25 513 Sales exist 4 25 497 5 25 72 6 8 72 Sales exist 7 8 497 Sales exist

 Cell Formula C2 =IF(COUNTIFS(Sheet1!A\$2:A\$10,A2,Sheet1!B\$2:B\$10,B2),"Sales exist","")

Excel tables to the web >> Excel Jeanie HTML 4

5. ## Re: Need To Match 2-3 Cells to Show A Result

Just tried this today as well and it worked also. Thank-you so much for the help! I really appreciate it

6. ## Re: Need To Match 2-3 Cells to Show A Result

Originally Posted by JHawks8221
Just tried this today as well and it worked also. Thank-you so much for the help! I really appreciate it
You're very welcome.