Multiple Lookups

[KG]

How do I organize a lookup situation such as the following:

- Column A contains the name of Salesmen
- Cells B1, C1, D1, and E1 display the names of products
- Cells in

 

[KG]

incomplete message, posted accidentally. Complete message follows