Results 1 to 12 of 12

Is there a way to merge information automatically from dissimilar tabs?

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    12

    Is there a way to merge information automatically from dissimilar tabs?

    I have one tab that has about 1000 uniquely identified items by name. Then on the second tab I have about 2000 items uniquely identified by name and serial number. I want to take one tabs information, match the items on tab two then return the serial number to a cell next to the matching item on tab one. See example below:

    Tab 1
    Serial # Item Name
    Desk
    Keyboard
    Monitor
    Mouse

    Tab 2
    Serial # Item Name
    159263 Desk, Small
    134570 Desk
    321146 Keyboad, Wireless
    449321 Keyboard
    157943 Monitor
    321648 Monitor, 15
    166624 Monitor, 17
    13476 Monitor, 19
    445568 Monitor, 20
    156461 Monitor, 22
    321648 Mouse

    I am open to an if formula, match, vlookup, etc. I am hoping someone else has already been there and done that, and will share.

    Thank you,

    DW
    Attached Images Attached Images
    Last edited by DW2054; 09-13-2011 at 12:29 PM.

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