Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2014
    Posts
    30
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Update the second sheet column

    Hi,

    One Workbook having 2 worksheet and want to update the second sheet column from first sheet.


    In Sheet1, Column D has reference No. and Sheet2 Column D has reference No. once matched copy Sheet1 Column G to Sheet2 Column X.

    Thanks in Advance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    You could do this via a formula:

    ..in column [X] on [Sheet2] enter this formula in cell [X2]:
    Code:
    =INDEX(Sheet1!G:G,MATCH(D2,Sheet1!D:D,0))
    ..and copy down as required

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    John_2014 (2016-05-06)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •