Excel formula question about finding a string in a column

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
mikeman
Forum Newbie
Posts: 18
Joined: Wed Apr 07, 2010 7:18 am

Excel formula question about finding a string in a column

Post 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.
Post Reply