Results 1 to 4 of 4

Match account numbers to 2nd column (vlookup?)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Match account numbers to 2nd column (vlookup?)

    I would like to match the account numbers from the "Old info" to the accounts in the "New info". Need formula in yellow area. If no account matches from New info to Old info.. then just leave blank.

    The account wording is slightly different from Old and New. I don't know how to match them if the wording isn't exactly the same. Vlookup "approximate" match didn't work for me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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