View Single Post
  #4   Report Post  
DOR
 
Posts: n/a
Default 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