Hello,

The scenario:
My company ships hazardous materials. We use a variety of shipping companies (i.e. fedex / ups) who offer a host of service levels (ground, overnight) . Not all of our hazardous products are able to be transported by every shipping service level. To see if a product is able to be transported via a certain shipping service, I have a simple table set up listing each product in rows, and shipping service in columns. When crossed, a green or red cell indicates that this scenario is acceptable, or not acceptable. My list of products is somewhat extensive (~100) with about 20 service levels, and therefore this table is inconvenient to use.

I would like to have a cell where i enter a product (part#) and a shipping service (3-digit code), a third cell would result with "Compatible" (green fill) or "Not Compatible" (red fill).

Ideas?