Get Excel to insert specific text in a cell when another cell contains specific word(s)

Does anyone of you know what kind of formula I should use if I want Excel to insert a specific text when another cell contains a specific word?

Example:

Cell 1
(empty)

Cell 2
Production of product X

Cell 3
Category Z (under which production companies belong)

So I want cell 1 to automatically be filled with the content of cell 3 when a part of the text in cell 2 matches a word I use as a reference, i.e. 'production').

Attached is the file I intend to use it for (it's in Dutch, but the word 'vervaardiging' means 'production').

Cell 1 from my example corresponds with cell D3 on tab 1. Cell 2 from my example corresponds with cell F3 on tab 1. Cell 3 of my example corresponds with cell N3 on tab 2.

Hi,

In the attached sheet, I couldn't find any value in said N3 of tab2. But anyway, copy paste the below formula in d3. See if this works.

Please Login or Register  to view this content.

Fantastic! The value in N3 was text, maybe I should've mentioned that more clearly... anyway, thanks very much.

You're welcome

-----------------------------------------------------------------------------------------------------------
If the reply solved your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)
If my reply helped, Please add reputation (click on the star below the post)