I want to create some sort of formula where I can insert text into a new cell if a specific cell in the same row matches one in a certain column.
But I need to use multiple situations with it.
If C3 text matches anything in column K then Insert "bob" into C4.
Or If C3 matches any cell in Column J then insert "Joe" into C4
Or if C3 matches any cell in Column L then insert "Larry" into C4
Any help would be greatly appreciated!!
Solved by S. H. in 25 mins