VLOOKUP ???

[Jeanette]

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?

 

[Per Erik Midtrød]

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?

I think you will be better off with a mix of Match and Index, someting
like:
=INDEX(C:C;MATCH("Yes";L:L))

This will return the value in C from the first row i column L that
equals "Yes"

Per Erik

 

[Jeanette]

Whn I try that formula, it gives the last value row value for "yes" how do I
get it to provide the first row value?

 

[Per Erik Midtrød]

Whn I try that formula, it gives the last value row value for "yes" how do I
get it to provide the first row value?

Sorry, guess I didn't test it good enough,
just insert lookup type 0 and I think it does what you need:
INDEX(C:C;MATCH("Yes";L:L;0))

Per Erik

 

[Jeanette]

Thank you so much ~ You are amazing ;-)

Sorry, guess I didn't test it good enough,
just insert lookup type 0 and I think it does what you need:
INDEX(C:C;MATCH("Yes";L:L;0))

Per Erik