I have a worksheet with a large amount of production data broken up into production years and what I am needing is to find the last data entered in a column if the production year matches.

What I need it to do is look at column B last row and if the cell on Sheet3 D3 matches number in column B last row data entered it will return the last data from column J entered for that production year.

Thank you are any and all help

A B C D E F G H I J K
Row Day of Production Production Year # Total ABC Production Pipe QC Total ABCQC Production Total Daily Production Start Date End Date Total Year Production Total Year Over Contract ABCQC
Over Contract
2 10
3 10
4 10
5 10
6 10