Hi guys
A very simple one here but I can't work it out (tried searching but my query involves the words 'if', 'match', 'cells' and 'list' so I'm finding all sorts of answers on the web but not the answer I'm looking for.
If word in column C matches what I am looking for (either as fixed "word" or based on a specified cell) then list the data from the cells in the corresponding row from column A. So I have a list of employees and what area they work in. If they work in "sales" then all the names should be listed in one cell.
I've attached an example.
Many thanks
D
Bookmarks