I’ve received a data set which contains a delimited string where I need to extract a particular word from that data.
| Audit Type | Actual Result |
|---|---|
| Similar (BAU) Process | Similar |
| Hard Limit – QA Time Process | QA Time |
| 1 – Similar (BAU) Audit | Similar |
| 5 – QA Time | QA Time |
| 3 – OTT/LP Audit | OTT |
| 2 – Hard Limit / Training | Hard Limit |
| 4 – EXTND OTT/LP Audit | OTT |
| Hard Limit | Hard Limit |
| OTT/LP Audit | OTT |
| OTT Audit | OTT |
| EXTND OTT Audit | OTT |
I got the result but as a learner looking for the better solution than this formula. & also my result is incorrect.
=LET(a,$A$2:$A$12,b,IFS(SEARCH("Similar",a),"Similar"),c,IFS(SEARCH("OTT",a),"OTT"),d,IFS(SEARCH("QA Time",a),"QA Time"),e,IFS(SEARCH("Hard Limit",a),"Hard Limit"),IFERROR(e,IFERROR(d,IFERROR(c,IFERROR(b,a)))))
Thank you.