Results 1 to 2 of 2

Thread: Merging 2 worksheets using the data from 2 columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Merging 2 worksheets using the data from 2 columns

    Hi,

    I'm a bit of a newbie with Excel. Please could someone help me.

    I have 2 worksheets, sheet 1 and sheet 2, and I want to merge the matching data from sheet 2 onto sheet 1.
    The problem I have is I need to use times, in column B, and names, in column C, to cross reference with the same data on both worksheets.
    I've looked at VLOOKUP but all the videos etc. only show how to use one column of data as a cross reference.
    I also tried to concatenate the times and names into one column but couldn't get it to work, I ended up with a long string of numbers.

    Unfortunately I don't know how to upload the worksheet here or a jpeg.

    Thank you in advance for any help and guidance.

    Matt

  2. #2
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,645
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Merging 2 worksheets using the data from 2 columns

    Dadders,

    Welcome to the MrExcel forum.

    I don't know how to upload the worksheet here or a jpeg.
    You can post your workbook/worksheets Sheet1, and, Sheet2, and, what the results (manually formatted by you) should look like, to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

    https://dropbox.com
    Last edited by hiker95; Feb 18th, 2018 at 08:42 PM. Reason: add additional information
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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