C
carl
I have 2 Tables and am trying to use them to tell me if
my saleteam is selling the products that they have been
assigned too.
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
Product JB JW
AIG
TWX 1 1
ABT 1
ALL 1
AXP 1 1
Table2
Product JB JW
AIG
TWX 12
ABT 12
ALL 12
AXP 12 12
I would like to create a table that would tell me IF the
Salesperson is Assigned to the Product, IF he sold any.
If the answer is yes, return OK. If the answer is no,
return CHECK.
Perhaps the 3rd table would look like this...
Product JB JW
AIG OK OK
TWX OK CHECK
ABT OK OK
ALL CHECK CHECK
AXP OK OK
Thank you in advance
my saleteam is selling the products that they have been
assigned too.
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
Product JB JW
AIG
TWX 1 1
ABT 1
ALL 1
AXP 1 1
Table2
Product JB JW
AIG
TWX 12
ABT 12
ALL 12
AXP 12 12
I would like to create a table that would tell me IF the
Salesperson is Assigned to the Product, IF he sold any.
If the answer is yes, return OK. If the answer is no,
return CHECK.
Perhaps the 3rd table would look like this...
Product JB JW
AIG OK OK
TWX OK CHECK
ABT OK OK
ALL CHECK CHECK
AXP OK OK
Thank you in advance