Comparing 2 Tables

C

carl

I have 2 Tables:

Table 1 has my list of products in rows and list of
SalesPeople in Columns. The table identifies (cell entry =
1) which Salespeople are assigned to each product.

Table 2 has my list of products in rows and the Salepeople
that have sold any of the products in Columns. The table
identifies how much each salesperson sold of each product.

Table1
Symbol Group BOX050 BOX060
AIG A0
TWX A1 1 1
ABT A2 1
ALL A3 1
AXP A4 1 1

Table2
FirmId BOX050 BOX060
AIG A0
TWX A1 12
ABT A2 12
ALL A3 12
AXP A4 12 12

I would like to create a table that would tell me IF the
Salesperson is Assigned to the Product, IF the Sold any.
If the answer is yes, return OK. If the answer is no,
return CHECK.

Perhaps the 3rd table would look like this...

FirmId BOX050 BOX060
AIG A0 OK OK
TWX A1 OK CHECK
ABT A2 OK OK
ALL A3 CHECK CHECK
AXP A4 OK OK

Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top