Hi everyone,
I have just started a new job today and have been asked to analyze some data in Excel. My Excel skills are pretty much limited to autosum so I'm hoping someone can help please so I don't look stupid on my first week at work! I'd like to point out my new boss knows my excel skills are zero, so I didn't get the job through deception
I have a spreadsheet with 2 worksheets, they have a different number of entries and no definitive reference data so I'm being forced to match on firstname and lastname. Here is an example:
Worksheet 1:
<tbody>
</tbody>
Worksheet 2:
<tbody>
</tbody>
As you can see, the only option I have to match on is a combination firstname and lastname. Whilst this certainly isn't perfect, it should get me most of the way there. So here is what I'm trying to do:
Compare the firstname and lastname in worksheet A to the firstname and lastname in sheet B.
If there is a match, copy the lastname and email address from sheet A, and the subscription status from worksheet B to a new worksheet.
So given the data above, this is the output I'm looking for:
<tbody>
</tbody>
At present I'm working through this manually as I just don't know how to automate the process, but there are HUNDREDS of entries in both worksheets and doing it manually just isn't practical, not to mention the likelihood of errors.
I have tried searching for a solution before posting here, but I'm not even sure what to search for, and I have no idea the formulas and function I should be using.
If anyone can assist I would be forever grateful!!!
Many thanks,
Matt.
I have just started a new job today and have been asked to analyze some data in Excel. My Excel skills are pretty much limited to autosum so I'm hoping someone can help please so I don't look stupid on my first week at work! I'd like to point out my new boss knows my excel skills are zero, so I didn't get the job through deception
I have a spreadsheet with 2 worksheets, they have a different number of entries and no definitive reference data so I'm being forced to match on firstname and lastname. Here is an example:
Worksheet 1:
firstname | lastname | title | email address |
willy | wonka | ceo | willy@wonka.com |
walter | white | chef | walter@white.com |
phil | dunphy | sales manager | phil@modern.com |
cosmo | kramer | jester | cosmo@seinfeld.com |
walter | cronkite | announcer | walter@radio.com |
<tbody>
</tbody>
Worksheet 2:
firstname | lastname | subscription | paid up |
amanda | hugnkiss | yes | yes |
willy | wonka | yes | no |
cosmo | kramer | no | no |
seymore | butts | yes | no |
amanda | seyfried | no | yes |
<tbody>
</tbody>
As you can see, the only option I have to match on is a combination firstname and lastname. Whilst this certainly isn't perfect, it should get me most of the way there. So here is what I'm trying to do:
Compare the firstname and lastname in worksheet A to the firstname and lastname in sheet B.
If there is a match, copy the lastname and email address from sheet A, and the subscription status from worksheet B to a new worksheet.
So given the data above, this is the output I'm looking for:
lastname | email address | subscription |
wonka | willy@wonka.com | yes |
cosmo | cosmo@seinfeld.com | no |
<tbody>
</tbody>
At present I'm working through this manually as I just don't know how to automate the process, but there are HUNDREDS of entries in both worksheets and doing it manually just isn't practical, not to mention the likelihood of errors.
I have tried searching for a solution before posting here, but I'm not even sure what to search for, and I have no idea the formulas and function I should be using.
If anyone can assist I would be forever grateful!!!
Many thanks,
Matt.