I’m trying to use this function:
=INDEX(‘WRP WK1’.$M$14:$M$312,MATCH(A16,‘WRP WK1’.$A$14:$A$314,1))
i know how it works, but I’m trying to MATCH names from one column to another, if the names are exactly the same it works.
But sometimes i have names that are formatted differently
example:
-
Abbrederis, Jared
-
Jared Abbrederis
how do I fix the MATCH part of the function to see different formats.
how do I have #1 find #2, and how do I have #2 find #1 …