For each record in the attached table, I'm trying to find the closest matching record within the table for columns E-R. Ideally the result would return the email address (found in column U) of the closest matching record in column w.
So basically the formula would have to compare one record with the rest of the records in the table to identify whether or not the values for each column in E - R match, then it would sum how many values matched across all those columns, and it would return the email address for the record that had the highest number of matches. We'd want to perform the same comparison for each record in the table so at the end each record would display a match. If a tiebreaker is needed we would compare the number in column S to see which value is closest.
Bookmarks