matching and lookup??
A somewhat shorter, but less obvious, formula than that in my previous
post, which will also handle non-numeric item numbers is:
=INDEX(A2:A8,MATCH(1,--(C2:C8=MAX((B2:B8=D1)*(C2:C8))),0))
Also an array formula - enter with ctl-shift-enter
|