Need unique rows displayed based on car no. selected through a drop-down menu

[Miloni]

Car No.	Date of Entry	Driver Name	Trip Start Date	Trip End Date	Trip No. of Days
1234​	01-08-2020​	abc	03-05-2020​	12-05-2020​	9​
4567​	02-02-2020​	jkl	05-02-2020​	09-02-2020​	4​
2589​	03-02-2020​	hijhk	03-02-2020​	07-02-2020​	4​
2358​	04-02-2020​	srdtfyj	07-02-2020​	09-02-2020​	2​
1234​	05-02-2020​	abc	09-02-2020​	17-02-2020​	8​
4567​	02-02-2020​	jkl	05-02-2020​	09-02-2020​	4​
8512​	03-02-2020​	hijhk	03-02-2020​	07-02-2020​	4​
1234​	04-02-2020​	srdtfyj	07-02-2020​	09-02-2020​	2​

If the Car No. selected is "1234"; the expected result in a different sheet should be as follows :

Date of Entry Driver Name
01-08-2020 Abc
05-02-2020 abc
04-02-2020 srdtfyj

I tried using vlookup, which is giving me the 1st result of date of entry 01-08-2020 and driver name abc.

Is it possible to get all the results displayed whose car no. is 1234 ?

Any help appreciated.

 

[Miloni]

Thank you so much for all your help. Appreciate it a lot.

 

[Toadstool]

Thank you so much for all your help. Appreciate it a lot.

You're welcome!