Need your help here to solve my query. Here is the simple and short example given, if I want to vlookup and partial vlookup from excel1 to excel2. How would I write in the IF condition.
Expected result: Charles Tee and Charles Elise T (exact match in vlookup) and Jane, Janet, Charles (partial match) as the First Name appear in both excels. If it is a long list like 400+ rows, I can’t use “contains”, so what should I write.