poleary2000
Active Member
- Joined
- Apr 1, 2002
- Messages
- 354
Hi all.
I have the following table:
Date Start Time Stop Time ID # User
1/7/2004 8:00 AM 11:35 AM 1213 Mary
1/7/2004 11:35 AM 12:38 PM 1214 Mary
1/7/2004 12:38 PM 4:30 PM 1214 James
1/7/2004 4:30 PM 4:50 PM 1214 James
1/7/2004 4:50 PM 8:00 PM 1211 James
1/7/2004 8:00 PM 11:59 PM 1213 Joe
1/8/2004 12:00 AM 4:00 AM 1213 Joe
1/8/2004 8:00 AM 12:15 PM 1214 Mary
1/8/2004 3:30 PM 3:40 PM 1213 Joe
1/8/2004 3:40 PM 4:45 PM 1214 Joe
1/8/2004 5:15 PM 11:00 PM 1214 James
1/8/2004 11:00 PM 12:00 PM 1216 James
1/9/2004 6:00 AM 1:00 PM 1214 Joe
Then, I have 5000 lines of transactions that have many, many columns. Two of those columns are Date and Time. What I want to do is to lookup the Date and Time of the transaction in the table above and return the ID # to a cell and the User to another cell. I have fooled around with Lookups and Match but I can't figure it out.
Help!
I have the following table:
Date Start Time Stop Time ID # User
1/7/2004 8:00 AM 11:35 AM 1213 Mary
1/7/2004 11:35 AM 12:38 PM 1214 Mary
1/7/2004 12:38 PM 4:30 PM 1214 James
1/7/2004 4:30 PM 4:50 PM 1214 James
1/7/2004 4:50 PM 8:00 PM 1211 James
1/7/2004 8:00 PM 11:59 PM 1213 Joe
1/8/2004 12:00 AM 4:00 AM 1213 Joe
1/8/2004 8:00 AM 12:15 PM 1214 Mary
1/8/2004 3:30 PM 3:40 PM 1213 Joe
1/8/2004 3:40 PM 4:45 PM 1214 Joe
1/8/2004 5:15 PM 11:00 PM 1214 James
1/8/2004 11:00 PM 12:00 PM 1216 James
1/9/2004 6:00 AM 1:00 PM 1214 Joe
Then, I have 5000 lines of transactions that have many, many columns. Two of those columns are Date and Time. What I want to do is to lookup the Date and Time of the transaction in the table above and return the ID # to a cell and the User to another cell. I have fooled around with Lookups and Match but I can't figure it out.
Help!