I have three lists; List A (name and Reason), List B (Name) and List C (Name). I need a function to match each name in List C with names of the list A and B and return the corresponding reason in List A if it is matched and blank if it is not matched.
Bookmarks