How to find the last value in an array with gaps Excel M365

Hi folks, I'm trying to find the last date for a customer in an array which rows has blank values.

I'm currently trying to use an Index function as I think this will help with the gaps.

For example, if we supply a customer which is listed in row 4 and row 12 with a blank anywhere in between row 4 and row 12, I want to return a date value that is at the intersection of row 12 and column 2 if that makes sense.

I've got this big table and customers repeat periodically throughout and I'm trying to find the date value the last time the customer appears.

I'm trying to work out using an Index function because my array has rows where there is no value.

Below, is an example of how the table looks. If i was looking for the last time Customer 4 appears, I'd like for it to return the Supply Date value of 21/5/2026.

Customer Name Supply Date

Customer 1 18/05/2026

Customer 2 18/05/2026

Customer 3 18/05/2026

Customer 4 18/05/2026

Customer 5 18/05/2026

Customer 6 18/05/2026

Customer 7 18/05/2026

• Blank line -

Customer 8 21/05/2026

Customer 9 21/05/2026

Customer 10 21/05/2026

Customer 4 21/05/2026

Customer 11 21/05/2026

Customer 11 21/05/2026

Customer 11 21/05/2026

Customer 12 21/05/2026

Hopefully that is clear as mud.