vlookup with dates?

[Ian1976]

[TABLE="class: outer_border, width: 550, align: center"]
<tbody>[TR]
[TD="align: center"]U
[/TD]
[TD="align: center"]V
[/TD]
[TD="align: center"]W
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]Y
[/TD]
[TD="align: center"]Z
[/TD]
[TD="align: center"]AA
[/TD]
[/TR]
[TR]
[TD]6-Nov-18
[/TD]
[TD]7-Nov-18
[/TD]
[TD]8-Nov-18
[/TD]
[TD]9-Nov-18
[/TD]
[TD]10-Nov-18
[/TD]
[TD]11-Nov-8
[/TD]
[TD]12-Nov-18
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hi all,

not sure its possible but I have "A" column with serial numbers in 123456 and column "O" with dates in, what I'm trying to do is when I sort them in to date order I'd like it to populate a table like this...If the date in column O matches the date on the table in column U then paste in the related serial number, also any suggestion on what I can do if I have 2 dates the same?

Thanks
Ian

Column A Column O
123456 6-Nov-18
654321 8-Nov-18
456123 10-Nov-18

 

[RasGhul]

Hi Ian,

Try,
D1 is where I have entered 2 to limit the qty of numbers returned. You can change this to where you like or replace >$D$1 with 2.

=IFERROR(IF(ROWS(U$2:U2)>$D$1,"",INDEX($A$2:$A$11,SMALL(IF($O$2:$O$11=U$1,ROW($O$2:$O$11)-ROW($O$2)+1),ROWS(U$2:U2)))),"")