Formula

[Donkey]

How do I return the smallest value from one range based on another condition
from another range eg

 

[Frank Kabel]

Hi
e.g. the array formula
=MIN(IF(A1:A100="value",B1:B100))