find last value in a column if it meets a certain criteria

Hey there
I need help please to find last non blank cell in a column, and check if its corresponding cell in another column contains the word "L1", and return its corresponding date from another column.
Here is an attached example for better understanding.