Hi
I'm trying to implement a solution, which I found in several websites (i.e. exceljet.net, extendoffice.com; myonlinetrainghub.com), to a simple problem.
I would like to know if a cell contains one of several items within a list. I've enclosed a photo that shows my excel with detailed information on the formulas used.
The solution I'm implementing (please see the enclosed photo of my file), is working but ONLY if the cell and the item from the list are in the same row.
For example: cell B5 contains the word 'Yellow' which is in cell E5, thus the result is TRUE. Same is for cells B8 and E8. However, Cell B10 contains the word 'pink' which is in the list, but since they are not in same row ('pink' is in cell E9) I'm getting FALSE.
In the 2nd Table (B14:E21) all results are FALSE since none of the items in the list is in the same row as the cell that contains it.
This example is copied from exceljet.com (see link at the bottom of the picture). In exceljet the result for cell B10 is TRUE, while mine is FALSE. Can't figure it out…
Any ideas will be greatly appreciated.
Bookmarks