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
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