Need a function to do matching process and return the corresponding value

Iron Contributor


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 rason in List A if it is matched and blank if it is not matched.

2 Replies



You can try this formula.


@ajl_ahmed  Here is one option (see attached)