+ Reply to Thread
Results 1 to 2 of 2

move data from a sheet

  1. #1
    Registered User
    Join Date
    05-16-2007
    Posts
    1

    move data from a sheet

    Hi i have 2 worksheets

    sheet 1 column K is a list of phone numbers

    sheet 2 column A is also a list of phone numbers

    what i need to do is copy sheet 2 columns B, C, D, E
    to sheet 1 column L, M, N ,O

    if sheet 2 column A matches sheet 1 column K

    NOTE:
    there is duplicate numbers in both sheets, what i would really like is
    select unquie numbers from sheet 2, then insert into L, M, N ,O where the number matches

    can someone plz help, i have tried lookup but not quite sure what i am doing?

    Thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Have a look at HELP on the VLOOKUP function.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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