[Solved] Formula to LookUp most Recent Information

Hi,

I wonder if someone can help me...please.

How would you do the following

I want to populate column B in a worksheet with the current status of a lead from another worksheet containing the information by looking up the Lead ID in Column A and getting the data from Column B however the lead ID could be in the information worksheet multiple times and I want to get the most recent information. Column C in the worksheet contains the date and time the lead status was changed. It is also updated in real time so will change constantly. Can it be done?

First Worksheet looks like this:

Lead ID Current Status
99899483
99899423
99897194
99896768
99896519
99896448
99895034
99894700

The information looks like this:
Lead ID Status Date & Time Sold
99899483 Quoted 22/09/2015 11:18
99899423 Quoted 22/09/2015 11:15
99897194 Valid 22/09/2015 11:06
99896768 Declined 22/09/2015 11:05
99896519 Valid 22/09/2015 11:05
99896448 Valid 22/09/2015 11:05
99895034 Do Not Call 22/09/2015 11:02
99894700 Valid 22/09/2015 11:01
99894014 Valid 22/09/2015 11:00
99892630 Valid 22/09/2015 10:57
99891755 Quoted 22/09/2015 10:53
99889639 Valid 22/09/2015 08:49
99889126 Can't Beat Quote 22/09/2015 07:50
99888793 Valid 22/09/2015 03:27
99888552 Valid 22/09/2015 00:36
99886554 No Number 21/09/2015 19:43
99886407 No Number 21/09/2015 19:27
99883213 Valid 21/09/2015 15:48
99881028 Valid 21/09/2015 14:04
99881009 Valid 21/09/2015 14:03
99880854 Invalid 21/09/2015 13:54
99880717 Valid 21/09/2015 13:48
99880499 Invalid 21/09/2015 13:45
99880488 Quoted 21/09/2015 13:45
99879493 Quoted 21/09/2015 12:54
99878473 Valid 21/09/2015 12:06
99878088 Valid 21/09/2015 11:43
99877872 Valid 21/09/2015 11:29


Thanks in advance for your help.
Louise