Vlook On Duplicate Value (Date)

[Numaan Mujawar]

i have made 1 production planning sheet, in which i have added all the Job Order and against every order i have given a production plan date. Dates are repeated in other orders.

I want to extract Job Orders for a specific data, lets say for 24th Oct which job orders are planned. I tried doing vlookup but it is showing latest data for that date instead of showing corresponding data

 

[Numaan Mujawar]

i have made 1 production planning sheet, in which i have added all the Job Order and against every order i have given a production plan date. Dates are repeated in other orders.

I want to extract Job Orders for a specific data, lets say for 24th Oct which job orders are planned. I tried doing vlookup but it is showing latest data for that date instead of showing corresponding data

 

[AhoyNC]

What version of Excel are you using? If you have Excel 365 take a look at the FILTR function. Also, in your example I don't see a column for job orders. It would help if you could use XL2BB to post your example.