Match Dates to a Year in Excel

paulunh11

New Member
Joined
Mar 15, 2017
Messages
6
Hello,
How can I match the service date on the left to a car based on a Year?
For Example first Line should show 2017 Land Rover and 03-Mar-17, Second would be blank as Jaguar is not the service list with a 2017 date.
Please help.


Year Car Service Date Model Service Date
2017 Land Rover ?????? Land Rover 03-Mar-17
2017 Jaguar Kia 28-Apr-17
2017 Kia Fiat 28-Apr-17
2017 Mazda Ford 23-Jun-17
2017 Fiat Cadillac 30-Jun-17
2017 Ford BMW 28-Jul-17
2017 Hyundai Audi 15-Sep-17
2017 Cadillac SEAT 29-Sep-17
2017 Chrysler BMW 13-Oct-17
2017 BMW Toyta 20-Oct-17
2017 Audi VW 10-Nov-17
2017 Saab Chrysler 10-Nov-17
2017 SEAT Hyundai 02-Mar-18
2017 Toyota Cadillac 02-Mar-18
2017 VW SEAT 02-Mar-18
2018 Land Rover Toyta 02-Mar-18
2018 Jaguar VW 29-Jun-18
2018 Kia Land Rover 29-Jun-18
2018 Mazda Ford 29-Jun-18
2018 Fiat Mazda 31-Aug-18
2018 Ford Kia 14-Dec-18
2018 Hyundai Audi 01-Mar-19
2018 Cadillac BMW 24-May-19
2018 Chrysler VW 24-May-19
2018 BMW Land Rover 24-May-19
2018 Audi Jaguar 31-May-19
2018 Saab Kia 05-Jul-19
2018 SEAT Ford 05-Jul-19
2018 Toyota Hyundai 26-Jul-19
2018 VW Cadillac 08-Nov-19
2019 Land Rover Saab 08-Nov-19
2019 Jaguar
2019 Kia
2019 Mazda
2019 Fiat
2019 Ford
2019 Hyundai
2019 Cadillac
2019 Chrysler
2019 BMW
2019 Audi
2019 Saab
2019 SEAT
2019 Toyota
2019 VW
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
It seems like you need more info or perhaps using the add on Jeanie to attach an html of your worksheet.
 
Upvote 0
Hi. Please find the link to the file. I need service dates column G to be populated from column R based by year and car. So all dates in 2017 should be linked to cars in 2017 and so forth. Can you please help? https://mega.nz/#!mo02RKgA
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top