Comparing 2 Tables

C

carl

I am trying to create a table based on data in 2 other
tables.

Table1 has my products listed in rows and assigned sales
people in columns. There is a 1 in the cell if the
salesperson has been assigned to sell the product.

Table1
JIM BOB JOE ED
BOX1 1 1 1
BOX2 1 1 1 1
BOX3 1 1

Table2 records sales. Only sales people that have made
sales in on eo f the products gets recorded on the
table2 - thus not all salespeople are listed in table2.

Table2
BOB ED
BOX1
BOX2 22 10
BOX3 10

I am trying to create a 3rd table that will have the same
rows and columns as table1, but look at table2 and tell
me if a salesperson was assigned but did not sell the
product. For example...

Table3
JIM BOB JOE ED
BOX1 check check check
BOX2 check OK check OK
BOX3 OK check

I think this is possible but cannot get it done.

Thank you very much (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