I am using the below formula to return the smallest number in a range.
=SMALL(IF('YoY View - Dep & Cat'!$D$6:$D$108='Call Outs'!$C$4,'YoY View - Dep & Cat'!$U$6:$U$108),$B5)
I would like to return the label of the result, I'm having difficulty doing so.
For example the above formula would return '201.4' which is correct but I want a formula that will now return the label that accompanies this number i.e. Dave.
=SMALL(IF('YoY View - Dep & Cat'!$D$6:$D$108='Call Outs'!$C$4,'YoY View - Dep & Cat'!$U$6:$U$108),$B5)
I would like to return the label of the result, I'm having difficulty doing so.
For example the above formula would return '201.4' which is correct but I want a formula that will now return the label that accompanies this number i.e. Dave.