+ Reply to Thread
Results 1 to 2 of 2

Find matching cell in other sheet and copy cell from different column

  1. #1
    Registered User
    Join Date
    04-27-2011
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    8

    Find matching cell in other sheet and copy cell from different column

    Hi,

    Sorry I'm relatively new to this. I can write basic code but this is beoynd me. I think it might need a vlookup function but I'm not sure. I tried searching the forum but couldn't find anything close enough that I could modify. Maybe I'm not searching the right keywords?

    Anyway...
    I have two sheets (OLD and NEW) from a database of items we buy from our suppliers.
    After a recent software update the Stage Numbers (used to break up a job budget) got a bit muddled. The reason I can't do a straight copy and paste of the column is that there are new items inserted all through the sheet.
    A unique id for each item is in column B ("Item Number"), the Stage Numbers are in column AN.

    I need to be able to do the following:-
    For every row
    - find the corresponding item number in the OLD sheet.
    - copy the Stage Number from column AN to column AN in the NEW sheet.

    I have uploaded a very short version of the file. The actual list is over 50,000 items. In the file I have uploaded all the Stage Numbers happen to be 3.5 in OLD and 3.3 in NEW, but stored as text. Not sure if this is relevant.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Find matching cell in other sheet and copy cell from different column

    Try, in cell AN2 in the NEW sheet:

    =VLOOKUP(B2,OLD!B:AN,39,FALSE)

    and drag down.


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

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