I have a table with a description in column A. I want to be able to find a specif phrase that is in column D2:D99 and paste is in column C. I have been playing with this formula =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH("1A",A2)))))>0,"1A","") but i haven't figured out to search for a list of phrases. I have a list of phrases in cells
[TABLE="width: 500"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Date[/TD]
[TD]Postion[/TD]
[TD]List of seats[/TD]
[/TR]
[TR]
[TD]Seats 4C, 12F, 22D do not work[/TD]
[TD]4/19/2018[/TD]
[TD]4C, 12F, 22D[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]Seats 22LH do not work[/TD]
[TD]4/19/2018[/TD]
[TD]22A, 22B, 22C[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]Seats 1ABC do not work[/TD]
[TD]5/1/2018[/TD]
[TD]1A, 1B, 1C[/TD]
[TD]1C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1F[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2B and so on[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Date[/TD]
[TD]Postion[/TD]
[TD]List of seats[/TD]
[/TR]
[TR]
[TD]Seats 4C, 12F, 22D do not work[/TD]
[TD]4/19/2018[/TD]
[TD]4C, 12F, 22D[/TD]
[TD]1A[/TD]
[/TR]
[TR]
[TD]Seats 22LH do not work[/TD]
[TD]4/19/2018[/TD]
[TD]22A, 22B, 22C[/TD]
[TD]1B[/TD]
[/TR]
[TR]
[TD]Seats 1ABC do not work[/TD]
[TD]5/1/2018[/TD]
[TD]1A, 1B, 1C[/TD]
[TD]1C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1F[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2B and so on[/TD]
[/TR]
</tbody>[/TABLE]