I want to add a list of words in the part of the column under "IRU" (located in H216), as shown here:
iru.png
If cells B20-B131 contain "IRU" (with exact capitalization), I want to add the word from the adjacent cell to the list. For example, given that cell B124 (highlighted in green) contains "IRU": cell.png, I want to add the value in cell A124 (polyester): A.png to a cell under IRU as shown earlier. What formula can I use to accomplish this?
Edit: also attached is the excel sheet.
Bookmarks