Hi Mark,

Am Tue, 13 Oct 2020 16:14:25 -0700 (PDT) schrieb NoodNutt:

Formula should have been

{ =MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A5 ,Data!$G$2:$G$250)))}

no need to translate it. You can take it as it is.
E.g.:

Range("C1").FormulaArray = _
"=MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A 5,Data!$G$2:$G$250)))"


Regards
Claus B.
--
Windows10
Office 2016