1. User inputs two comma separated lists - list A and list B.
2. We take an element from the list A - and match it with the entire range.
3. Whichever cell from list B has the highest match, will be return against the values of User inputs two comma separated lists - list A and list B.

Can anyone try to solve this, I tried to use VLOOKUP with different set of functions but it didn't resolved this query. Link to excel sheet: