I have a spreadsheet that contains 2 sheets that I am trying to do a lookup on, I'm hung up on the greater/less than part of it, so any help I can get would be awesome
Transactions Sheet
Transaction Date/time
Employee ID
Event Sheet
Event ID
Employee ID
Event Start Date/time
Event End Date/time
I am trying to add a new field to the Transactions Sheet that will show an Event ID from the Event Sheet if:
Transactions Sheet-Employee ID matches Event Sheet-Employee ID
Transactions Sheet-Transaction Date/time >= Event Sheet-Event Start Date/time
Transactions Sheet-Transaction Date/time <= Event Sheet-Event End Date/time
There will be multiple rows of data for each Employee ID in both sheets, even on the same date, so I am trying to use the time for each record to see if a Transaction took place during an Event from the second sheet
Bookmarks