E

#### eflip

I have 2 tabs of data.

The first tab has info by product and its qualifying vendors and

non-qualifying vendors (the vendors are in seperate columns)

ColumnA ColumnB ColumnsC ColumnD ColumnE

Product X Vendor1 Vendor2 Vendor3 Vendor4

Column A will always be unique

Columns B and C are qualifying vendors and Column D and E are non-qualifying.

In the second tab I have the following:

ColumnA ColumnB

Product Vendor

What formula do I use to tell me if the vendor is Qualifying (Q) or

Non-Qualifying (N) or blank if the vendor is not included in the list.

Any help would be greatly appreciated!

Thank you in advance.