Evening again....
Please see attached work book.
I manage a varried vehicle fleet with different maintenance events at different times that's managed by a 3rd party application.
I run a report on that application and export the results into excel, copy and past onto my 3rd party Information Tab.
On my overview tab, i'm trying to combine similar maintenance events and timescales and auto populate the forecast.
I'm ok with index and match, but i have to manually select the relevant maintenace event to each vehicle(which defeats the purpose of trying to simplify things).
Question is: a) How do I match Overview Collumn B to 3rd Party Information Collumn A, and match each relevant maintenace event (Overview F4:N11) to 3rd party Information Collumn B and return the specific date that matches?
I've tried: =INDEX('3rd Party Information'!$A:$D,MATCH(1,('3rd Party Information'!A:A=$B12)*(('3rd Party Information'!B:B=$H$4)*('3rd Party Information'!B:B=$H$5)*('3rd Party Information'!B:B=$H$6)*('3rd Party Information'!B:B=$H$7)*('3rd Party Information'!B:B=$H$8)*('3rd Party Information'!B:B=$H$9)*('3rd Party Information'!B:B=$H$10)*('3rd Party Information'!B:B=$H$11)),0),7)
And slight variations, to no avail.
Please Help
Bookmarks