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

[ajl_ahmed]

Hi

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]

@ajl_ahmed 

=IFNA(VLOOKUP(VLOOKUP(I4,$G$4:$G$8,1,FALSE),$E$4:$F$14,2,FALSE),"")

You can try this formula.

 

[#3]

@ajl_ahmed  Here is one option (see attached)

=IF(ISNUMBER(XMATCH(I4,$G$4:$G$8)),XLOOKUP(I4,$E$4:$E$14,$F$4:$F$14,""),"")