I have a report of some Vehicle schedule, now, i want to get the specific Location for a given vehicle number of a given Date which is between two dates or equal to two dates amongst column B & C. I would like to look up for vehicle MH15EG4910 for calemder dates as shown in row H2:AK2 , if this date falls between the start trip date Column B and Trip End Date Column C within the report, then return its corresponding Trip Concatenating Start-End as shown Cell I4 Location name. Please help to sort out.
Output required as is available in cells I4 to L4, N4 to V4, Z4 to AC4, AD4 to AF4.
Data Source availabe in Table Range A2:E24.
I want Output for Vehicle Number Mentioned in Cell G4.
Thanks.
Bookmarks