Need To Match 2-3 Cells to Show A Result

JHawks8221

New Member
Joined
May 12, 2017
Messages
9
Office Version
  1. 365
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
1497
25513
872

<tbody>
</tbody>

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 NUMBERPRODUCT NUMBER
1497Sales Exists
25513
872Sales Exists

<tbody>
</tbody>

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!
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Here's one way.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
ABC
1COMPANY NUMBERPRODUCT NUMBER
21497Sales Exists
325513Sales Exists
425497
52572
6872Sales Exists
78497Sales Exists
Sheet2
Excel Workbook
AB
1COMPANY NUMBERPRODUCT NUMBER
21497
325513
4872
58497
Sheet1
 
Upvote 0
This worked perfectly! I can't thank-you enough for helping with this :) Thank-you again so much!
 
Upvote 0
Here is another way with a normal-entry formula

Excel Workbook
ABC
1COMPANY NUMBERPRODUCT NUMBER
21497Sales exist
325513Sales exist
425497
52572
6872Sales exist
78497Sales exist
Sheet2
 
Upvote 0
Just tried this today as well and it worked also. Thank-you so much for the help! I really appreciate it :)
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top