Show the value from a list for the adjacent cell

edit

Hi :-)

I need a function: If a search string (not case sensitive) is contained in an array of cells, show the value from a cell in an adjacent array as the function result (adjacent to the cell of the search string).

Example file attached. C:\fakepath\Examples paste fitting cell content.ods Would be happy about the solution in the example file.
No macros please.

Blessings, Klaus