Vlookup or Index Match Formula Needed

Hello,
I need a formula that matches the date and time from one set of columns to another and the result is the number next to that column.

EXAMPLE
Look Up Column
127 12/17/2014 2:00
126 12/17/2014 4:00
125 12/17/2014 6:00

Formula Columns
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
127 12/17/2014 2:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
126 12/17/2014 4:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00
125 12/17/2014 6:00

The formula matches the date and time from the lookup columns and the result is the # column.

Please see spreadsheet for a better understanding. Any and all help you could provide for any of the formulas would be greatly appreciated. Thank you.

One way: I9

Formula:

Please Login or Register  to view this content.

committed with Ctrl-Shift-Enter rather than just Enter. Then copy down.



Regards, TMS

You're welcome. Thanks for the rep.