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?

On Mon, 21 Mar 2005 08:45:04 -0800, "Jeanette"
wrote:

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

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 Midtrxd" wrote:

On Mon, 21 Mar 2005 08:45:04 -0800, "Jeanette"
wrote:

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

On Mon, 21 Mar 2005 09:19:06 -0800, "Jeanette"
wrote:

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


"Per Erik Midtrxd" wrote:

On Mon, 21 Mar 2005 08:45:04 -0800, "Jeanette"
wrote:

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

Thank you so much ~ You are amazing ;-)

"Per Erik Midtrxd" wrote:

On Mon, 21 Mar 2005 09:19:06 -0800, "Jeanette"
wrote:

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


"Per Erik Midtrxd" wrote:

On Mon, 21 Mar 2005 08:45:04 -0800, "Jeanette"
wrote:

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