Hello All,
See attached spreadsheet.
I have two sheets, "workersheet1" and "data". The "worksheet1" is speeding infractions and "Data" sheet is when projects and people had vehicles signed out. I would like to cross-reference the two together.
What I would like on "worksheet1" is the formula to populate columns J.
On the "Worksheet1" If the Vehicle Unit #(column B) and date (column H) matches the "Data" sheet Vehicle Unit #(column J) and date is greater or equal to start date (column E) and less than or equal to end date (column F) that it "Worksheet1" project number (column J) returns me the value of "data" sheet (column C)
I think this would be a vlookup task, but not picky if there are "if" forumlas that would work.
Any help is greatly appreciated.
Thank you,
Bookmarks