IF or V-Look Up (Cant Work it Out) PLEASE HELP! THANK YOU

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

Data Range

	A	B
20	Shoes
21	Tie
22	Shirt	Black, Gold, Brown, Silver, Lilac, Maroon, Scarlet, Mint, Grey, Cream, Royal Blue, Shiny Silver, Dark Green
23	Bag	Pastel, Grey, Cream, Royal Blue
24	Hat	Violet, Royal Blue
25	Jumper	Green, Pink, Green, Royal Blue, Hot pink
26	Scarf

Data Range

	B
20	=GetSpec(A20,$A$2:$AH$12)
21	=GetSpec(A21,$A$2:$AH$12)
22	=GetSpec(A22,$A$2:$AH$12)
23	=GetSpec(A23,$A$2:$AH$12)
24	=GetSpec(A24,$A$2:$AH$12)
25	=GetSpec(A25,$A$2:$AH$12)
26	=GetSpec(A26,$A$2:$AH$12)

What causes those cells to change color?

Originally Posted by FDibbins

What causes those cells to change color?

CF

Myself also wanted to give formula solution but if the OP wants to return the concatenated values of matching results then we have to go for VBA. Since many matching cells found for one condition in OP's file