I want to look up value in column c when column l reaches specific criteria.

for example:

when column L changes from 'No" to "Yes" what is the value in column C same
row as the change occurs?