Need serious assistance. Please see images below for a reference.
I have 2 sheets – The second image represents a sheet that is connected to a Google Form. This inputs the site information for various machines. Machines can move between sites on different weeks.
The first image represents a sheet that aggregates various data inputs for daily fuel consumption. The intention here is to have the Site column represent where the machine would have been Located on the date that the timestamp of fuel consumption on this sheet is recorded.
I want to lookup the site location that a machine would have been at if the timestamp that the fuel is recorded falls after a date that the machine location changed. the chalenge here is maintaining historic locations as the sites move around with Google Form entries.