View Single Post
 
Old 05-21-2019, 12:59 PM
p45cal p45cal is online now Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 318
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

in cell I4, array-enter:
Code:
=MIN(IF((($A$1:$C$3=$H$2)*($D$1:$F$3=$I$2))=1,$A$5:$C$7))
It returns the smallest result if there are more than one (eg. if x and y were both 1).


edit post posting: It's probably wrong.
Try instead, still array-entered:
Code:
=MIN(IF((CHOOSE({1,2,3},$A$1:$A$3,$C$1:$C$3,$E$1:$E$3)=$H$2)*(CHOOSE({1,2,3},$B$1:$B$3,$D$1:$D$3,$F$1:$F$3)=$I$2)=1,$A$5:$C$7))
Reply With Quote