My issue is making a formula that looks for the smallest number within a range (P10:U20) and when it finds the smallest number puts the number in cell a5 and if it was found in say P12 then it would return whatever is in O12 in cell A2. If the smallest number was found in U18 then it would return whatever is in cell O18 in cell a2.
Bookmarks