search multiple strings and copy in libreoffice calc

To summarise my problem, I have a sheet of file-names and locations, and the whole thing is a mess.

I want to search for multiple strings in rows B to E. If the first string is there, copy the result to column A. If it is not, move on to the next string, if it is there, copy to A. And so forth. If no strings are found, copy the cell in column B.

For example, two rows could go

H:\fruit\apple 001.frt - H:\fruitreplacement\newapple 001.frt - H:\fruit\new\Apple 001 (Banana).frt

H:\fruit\apple 002.frt - H:\fruit\new\Apple 002 (fruit).frt

In this example, the strings could be Replacement and New, ie, the first row would return fruitreplacement and the second would return new\apple.

I can barely get any result, despite a lot of searching and experimentation. I've begun by trying to set up something that finds even one string. The best result have been with an HLOOKUP, except that it only shows the last result of the line. As for actually finding what I want, no dice.