I am attempting to look up names in a list, but some of the names may be shortened. To account for the alternate/short names, I've created a list of substitutions on another sheet. My problem is, I don't know how to substitute the alternate/short names for those in the original list. The part I'm finding difficult is that some names have many alternates, and I want to search the whole list, then substitute all the names in that row for the first name in the original list.
I'm attaching the file I'm working with, I'd appreciate any help, even pointing me in the right direction. The file is just an outtake, I'll have thousands of original names, and all the names in the original list should return results.
Bookmarks