Results 1 to 4 of 4

Copy table column to another table column if cells are identical

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    Charleston, SC
    MS-Off Ver
    Excel 2010
    Posts
    25

    Copy table column to another table column if cells are identical

    I have two Tables, Table1 and Table2, in a single Excel spreadsheet. Table1 is our master log, and Table2 contains only Provider Names, Contact Names, Phone Numbers, and Email Addresses. I need to compare column K from Table1 with column AT from Table2. Whenever Excel finds a perfect match, I need Excel to copy AW:AY to AB:AD. For each value in column AT, there will be several identical matches in column K.

    I have search long hours for a solution, have tried to implement vlookup() and index(match()), but cannot figure either one of them. Any help would be greatly appreciated.

    fyi, Table1 is almost 1500 rows long, while Table2 is not quite 80.
    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