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.
Excel formula question about finding a string in a column
Moderator: General Moderators