lookup a value from a list excluding a previously found value
 

Hello,

My question is the following:

I have the following list

Name Date Value
A 20-jan-07 100
B 25-jan-07 90
A 5-feb-07 150

If I use the formule {index(value,Match(A,Name,0))} then the number
100 will appear.
How can I insert a formula in the next cell, that also looks for the
name A, but gives me a result of 150, and the date 5-feb-07?

Thank you,

avializq

lookup a value from a list excluding a previously found value
 

Autofilter on name, then pick each item in sequence
--
Gary''s Student - gsnu200726


" wrote:

Hello,

My question is the following:

I have the following list

Name Date Value
A 20-jan-07 100
B 25-jan-07 90
A 5-feb-07 150

If I use the formule {index(value,Match(A,Name,0))} then the number
100 will appear.
How can I insert a formula in the next cell, that also looks for the
name A, but gives me a result of 150, and the date 5-feb-07?

Thank you,

avializq

lookup a value from a list excluding a previously found value
 

This will return the value corresponding to the *LAST* instance of name A:

=LOOKUP(2,1/(Name="A"),Value)

Biff

wrote in message
ups.com...
Hello,

My question is the following:

I have the following list

Name Date Value
A 20-jan-07 100
B 25-jan-07 90
A 5-feb-07 150

If I use the formule {index(value,Match(A,Name,0))} then the number
100 will appear.
How can I insert a formula in the next cell, that also looks for the
name A, but gives me a result of 150, and the date 5-feb-07?

Thank you,

avializq