I have a spreadsheet containing details of dates/times and phone numbers sorted by dates.

On a second separate worksheet I have the numbers and another column of who wons the numbers.

I want to create a formual on a new column in the first worksheet to scan the numbers on the second and populate a new column with the owners names.

I am struggling with the right formula. VLOOKUP is not working unless the formual is more complicated than I understand??