Results 1 to 3 of 3

Use alternate names in a lookup

Threaded View

nmprodan Use alternate names in a... 11-21-2012, 01:46 PM
oeldere Re: Use alternate names in a... 11-21-2012, 02:01 PM
nmprodan Re: Use alternate names in a... 11-21-2012, 02:12 PM
  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Cleveland, OH
    MS-Off Ver
    2010
    Posts
    9

    Use alternate names in a lookup

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1