Hi all
I have 2 spreadsheets in a file which I attach. In the metadata spreadsheet, I need to check if the product field of items in Yellow highlight exists as a partial match (cell to contain at least one of the words in the metadata cell) in the Product field cell of the master list spreadsheet. For example. Take row 84 of the metadata table. That's the product Valio Cheese xorhgos. In Row 7872 of the master list spreadsheet there is valio cheese which contains at least one of the words in my metadata cell. So ideally we would run this as a vlookup for partial match on column M of the metadata table.
Bookmarks