Hello,
I am an Excel 2003 user.
I need to populate a column in one sheet based on a date stamp record falling within start and end time stamps and an additional column value in a second sheet.
I have tried a VLOOKUP function, but I do not know if that is the correct method.
I need to:
1. Check the start time column of the sheet called records.
2. If that start time is greater than or equal to and less than or equal to the start time and end time columns of the team schedule sheet, then populate the team column in the records sheet with the corresponding team letter designation from the team schedule sheet.
The VLOOKUP simply looked at the same row of the team schedule sheet as the records sheet; I don't know if it can examine the sheet in it's entirety. Also, I'm unsure of how to copy the team designation to the team column if a match occurs.
Thank you for your time. I've spent a few hours looking up past threads here, but am not making much progress.
I am an Excel 2003 user.
I need to populate a column in one sheet based on a date stamp record falling within start and end time stamps and an additional column value in a second sheet.
I have tried a VLOOKUP function, but I do not know if that is the correct method.
I need to:
1. Check the start time column of the sheet called records.
2. If that start time is greater than or equal to and less than or equal to the start time and end time columns of the team schedule sheet, then populate the team column in the records sheet with the corresponding team letter designation from the team schedule sheet.
The VLOOKUP simply looked at the same row of the team schedule sheet as the records sheet; I don't know if it can examine the sheet in it's entirety. Also, I'm unsure of how to copy the team designation to the team column if a match occurs.
Thank you for your time. I've spent a few hours looking up past threads here, but am not making much progress.
