hi and welcome to the forum
may be in b2 use below
copy paste below then hold control and shift together and then hit enter
Formula:
=MIN(IF((A2='Tube Prices'!$A$2:$A$6)*(C2>='Tube Prices'!$B$2:$B$6)*(D2<='Tube Prices'!$C$2:$C$6),'Tube Prices'!$D$2:$D$6))
array formulas are...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Bookmarks