Page 1 of 1

Excel formula question about finding a string in a column

Posted: Fri May 14, 2010 5:52 am
by mikeman
I have a list of of product codes in column A.

In columns B, C, D I have a header which is the product category and beneath it the list of asscoiated codes.

What I am after is an equation that takes the prod codes in column A and looks for it in columns B,C,D and if it finds it then it displays the header name from that column.