Show the value from a list for the adjacent cell
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