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
<tbody>
</tbody>
Description | Date | Postion | List of seats |
Seats 4C, 12F, 22D do not work | 4/19/2018 | 4C, 12F, 22D | 1A |
Seats 22LH do not work | 4/19/2018 | 22A, 22B, 22C | 1B |
Seats 1ABC do not work | 5/1/2018 | 1A, 1B, 1C | 1C |
1D | |||
1E | |||
1F | |||
2A | |||
2B and so on |
<tbody>
</tbody>