GENTS T SHIRT Black 2XL
GENTS T SHIRT Black XL
GENTS T SHIRT Blue Large
GENTS T SHIRT Grey 2XL
Assuming this being on A1 , formula required on B1 to mark Y if A1 has 2XL then on C1 I want formula to pull out colour , the colour will usually be the second last word
Bookmarks