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.
Examples paste fitting cell content.ods
Would be happy about the solution in the example file.
No macros please.