How to find last date used of a listed number

[_dave]

Last Date.ods (45.8 KB)

I have five columns of numbers (B to F) inserted by dates the number were drawn. How can I find the “date” of the last time the number was drawn and place it in “Last Drawn Date” column?

Example is the number “11” was drawn 4 times and the last time was on 03/04/2022. So, I would want that date be in column K14.

I can then use the same solution for the “Mega Ball” last drawn date.

Thanks ahead for any help and suggestions.

[JohnSUN]

Maybe =SUMPRODUCT(MAX(IF($B$4:$G$50=$H4;$A$4:$A$50;"")))?

Update. Don’t forget to set a format that will hide the “zero date” 12/30/1899 - for example with the format code MM/DD/YYYY;;;

[_dave]

JohnSUN, thank you. Perfect solution! And thanks for the “zero date” work around.