Multiple VLookups??

[poleary2000]

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!

 

[poleary2000]

Can't get it to work. I wish I could attached the sheet but it is 12 MB.

It seems to be pulling the wrong information from the right columns.

 

[poleary2000]

I used a VLookup instead. I moved the concat time to the first column and it is easy now. Thanks for all of your help!

 

[just_jon]

OK; Can't understand why the Index/Match failed. What's the VLOOKUP formula you're using?

 

[poleary2000]

=VLOOKUP(H2,'PDA Signout'!A:F,5,TRUE)

 

[just_jon]

OK, going for an approximate match; the == index/match formula would be --

=INDEX(D:D,MATCH($G2&CHAR(127)&$H2,F:F),0)

leaving off the ,0 bit in MATCH; requires the table to be sorted as does your VLOOKUP...