Hi,

I have this scenario below, in column A I have the descriptions and in column B I would like it to look up column A and find "2P" or "3P" and return just the numerical value in column B. I have tried with "if" and "right" statements but I cannot seem to get it right. The purpose of this exercise is just to find out how many packs are in each of the styles (ignoring the 90ml/3oz sizes, if possible). Thanks for your assistance.

A B
1 Everyday Pants 2P
2 Everyday Pants 3P
3 Shape Sleek Short
4 Silhouette Pants
5 Soak Bottle 90mL/3oz
6 Everyday Pants 4P

Regards,
Neelam