Results 1 to 7 of 7

Match / Index Multiple Columns and copy data

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2009
    Location
    Derby, England
    MS-Off Ver
    Excel 2003; Excel 2007
    Posts
    20

    Match / Index Multiple Columns and copy data

    hi,

    I've spent quite a few hours today trying to search for a solution to this and concluded it has something to do with Match and Index, but, can't for the life of me to get it all to work.

    I don't think it strictly has to be a macro - a formula may work - but this is what i want to do:

    In one sheet (called db) i have over 50,000 entries which relate to stock items seperated into style, colour, size and barcode.

    In the other sheet i have a download of my stock database (called stck) which (after some manipulation) also has columns split into style, colour and size. This has about 700 items in it.

    What i need to do is for all 700 items search through the db sheet and match style, colour and size, then copy the barcode from the db sheet to the stck sheet.

    I know it ***should*** be simple to do, but, i can't for the life of me work it out, so any help / advise / solutions would be really really appreciated.

    My excel sheet can be downloaded as a zip from here:
    http://www.surplushardwaresupplies.c...xcel/addbc.zip

    The upload utility keeps erroring on me for some reason, sorry...

    Thanks

    Mike
    Last edited by SHS; 04-07-2010 at 08:47 AM. Reason: Solved

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