Hi All,
I have two separate sheets with names which I want to link using V-lookup using False as criteria (exact finding). However in one sheet voor women the maiden name is in front.
For example:
- sheet one: Jansen-Bush
- sheet two: Bush-Jansen
I want also in sheet two the notation Jansen-Bush.
I can only solve this problem with a very large formula. Has some of you a solution??
Thanks!
I have two separate sheets with names which I want to link using V-lookup using False as criteria (exact finding). However in one sheet voor women the maiden name is in front.
For example:
- sheet one: Jansen-Bush
- sheet two: Bush-Jansen
I want also in sheet two the notation Jansen-Bush.
I can only solve this problem with a very large formula. Has some of you a solution??
Thanks!