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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
L

Legacy 396030

Guest
It seems like you need more info or perhaps using the add on Jeanie to attach an html of your worksheet.
 

paulunh11

New Member
Joined
Mar 15, 2017
Messages
6
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
 
L

Legacy 396030

Guest

ADVERTISEMENT

Check out how to insert an html of your file in the help section here.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,522
Messages
5,572,637
Members
412,476
Latest member
luihp329
Top