Dear Team,
Could you please help me with the comprehensive formula to derive the following output. It will be useful for vlookup formula.
Input
1. Arif Asgar Lala
2. Arif Lala
1st Output required
1. Arif Lala
2. Arif Lala
2nd Output required
1. Arif Asgar
2. Arif Lala
There are thousands of rows to match.
The conditions will vary depending on the requirement of the management.
Please assist.
Bookmarks