Edited as response to comment: I had to copy data into a new sheet, which is why it doesnt entirely match your answer.
Hope you can help with this one, usually get on OK with a function or two, but this wont work for me :-)
I need a code in N24 that currently says #ERROR! to do the following: If G24 = AAA AND H24:L24 contains the text DEL 1, it should show E24 (3).
The result should be, under LIST, there should be a 3, because DEL 1 is selected in one of the cells. It should check the entire H-L columns, but only list the cell-info from the TEXT-column, if that same line also has AAA in STATUS.
Hope it makes sense.