Thread
:
Array Function with VLOOKUP
View Single Post
#
5
CoRrRan
Posts: n/a
Domenic wrote in news:domenic22-
:
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)
Dominic, thank you very much! This function works perfectly. (However, for
the sake of the example: A1:A3 and C1:C3 should be A1:A100 and C1:C100.)
Many thanks for pointing me to the LOOKUP-function itself. I'll try to use
this function somewhat more often.
And the second formula also results in the correct answer. And I do need
the exact values. But your examples provide enough basis for me to continue
this!
Many thanks!
CoRrRan
Reply With Quote