Finding multiple substrings in a cell

[wzzl1]

Hello kind people of this forum. I have to do a substantial amount of data analysis for my master thesis and I am kind of getting stuck. I hope you will be able to help me with this issue. Ill give an example which is not actually in my thesis but a little easier to explain:

-The first row contains a database of cars. Each cell has three data values separated by commas: the brand, colour and year it was manufactured. e.g. "Toyota, green, 1998"
-It is a big database, like 10000 cars.
-In the second row I want to return a different value if the cell contains a certain type of car. For instance I want the country the car was manufactured in. Eg. if 'Toyota' is found return 'Japan'. If 'Citroen' is found, return 'France' and if 'Porsche' is found, return 'Germany'.

Normally I do this with the FIND function:

=IF(ISNUMBER(FIND("Toyora",A1)),"true","false")

...but now I have to search for multiple substrings and I want to use a single formula to extend to all of the cells.

Anyone helping me is advancing science! Thanks in advance.

 

[Oeldere]

I should solve that use text to columns and use , as a separator.

Then you have 3 columns of data.

For the country I would make a table with car / country and use VLookup to find that country in column D.

 

[Special-K99]

You'd do better to have three separate cells each for each record on the database (brand colour year)
Create a table of brands and countries
Then just do a VLOOKUP on the brand against your Brand/country table.