vlookup with dates?

[Ian1976]

U	V	W	X	Y	Z	AA
6-Nov-18	7-Nov-18	8-Nov-18	9-Nov-18	10-Nov-18	11-Nov-8	12-Nov-18

<tbody>
</tbody>

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)))),"")