Finding latest match in range
Tested?
"Sean Timmons" wrote:
=INDEX(A1:B100,MATCH("abc",A1:A100),2)
Will find the last value with "abc" in it and return the matching value in
the 2nd column.
"IGM" wrote:
Hi:
I have
abc 0
abc 10
abc 20
abc 30
efg 0
efg 10
abc -20
efg 50
How can I express a formula to obtain -20 for "abc"
and 50 for "efg" out of this data?
My goal is to get the numeric value (B) corresponding to the highest
matching row within the specified range.
Thanks,
IGM
|