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

Question

HiI 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.

oliverscheurich · Answer

ajl_ahmed&nbsp;=IFNA(VLOOKUP(VLOOKUP(I4,$G$4:$G$8,1,FALSE),$E$4:$F$14,2,FALSE),"")You can try this formula.&nbsp;

mtarler · Answer

ajl_ahmed&nbsp; Here is one option (see attached)=IF(ISNUMBER(XMATCH(I4,$G$4:$G$8)),XLOOKUP(I4,$E$4:$E$14,$F$4:$F$14,""),"")&nbsp;

Forum Discussion

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

Share

Resources