Categorize based on multiple criteria & conditions

[Annabolt]

Hello - I am looking for help with the following. Thanks in advance!

I have a column with values that need to be categorized based on multiple criteria. I would like to categorize using below logic:

If value contains "X" Or "Y", categorize as "Category1", if contains "A" or "B" or "C" categorize as Category2, if contains "M" or "N" or "O", categorize as category 3, else "other"

I was using a vlookup contains as per below but I am getting return values for blank cells and the wrong values for others. Is something wrong with the formula or should I try another way? I think an IF statement could work but I have a lot of criteria and I'm not sure how to specify "contains" with multiple criteria.

=VLOOKUP(I25&"*",Sheet2!E4:F10,2,FALSE)

Thanks!

 

[JackDanIce]

Welcome to the board.

I think the formula isn't correct, however, can you give examples for your values and expected results?

At a guess you need to have exact matches in column E of Sheet2 and you're trying to perform fuzzy logic matching so the formula isn't returning results you're expecting