Wow--where does one learn of that syntax for LOOKUP? Works great!

"Mike H" wrote:

Hi,

Assumes your data are in columns A&B

=LOOKUP(2,1/(A1:A20="ABC"),B1:B20)

Mike

"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