Morning all,
I might struggle to explain this one, so please bear with me if the question is unclear.
I'll elaborate below, but this is the end result I want to see:
A B C Dark Green Box RED GREEN Yellow Flower Pot YELLOW YELLOW Gold Coin GREEN GOLD Blue Fish BLUE BLUE Cured Ham BLACK RED WHITE GOLD SILVER
Columns A and B are populated by me, I want a formula in column C to look at the contents of column A on the same row, and see if anything in all of column B matches. If it does, I want it to return the contents of column B.
In reality, column B is in a separate worksheet, but I assume the formula is much the same even if the columns are right next to each other.
Any ideas on how this can work?
Bookmarks