Hi Guys,
I need some help in VBA Macro, I have a list of names in Column A and B. I want to search() the Column A names to the entire range of Column B names. and need the matched names in the Column C.
Column B names are Exact or Partial names of column A.
Not Found in B ColumnJantonio
Column A | Column B | Output |
Simon | Michael Littlewood | Not Found in B Column |
Edward | SigmondMichael | Edward |
Reid | Jantonio Scofield | |
Michael | BurtonMulberry | Michael |
Burton | Onstine Reid | Burton |
Jantonio | Burton |