Thread
:
Array Function with VLOOKUP
View Single Post
#
4
Domenic
Posts: n/a
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)
Reply With Quote