Merging 2 worksheets using the data from 2 columns

Dadders

New Member
Joined
Feb 18, 2018
Messages
1
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
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,648
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:

Forum statistics

Threads
1,085,314
Messages
5,382,923
Members
401,809
Latest member
jbeanx80

Some videos you may like

This Week's Hot Topics

Top