View Single Post
  #4   Report Post  
Domenic
 
Posts: n/a
Default

Correction...

=MIN(IF(ISNUMBER(MATCH(A1:A3,H1:H3,0)),C1:C3))

....confirmed with CONTROL+SHIFT+ENTER.

In article ,
Domenic wrote:

=MIN((ISNUMBER(MATCH(A1:A100,H1:H3,0)))*C1:C100)