I have an array formula as follows :-
={IF(($C$11:$C$15000=C11)*($AT$11:$AT$15000-BM11<0.001),$B$11:$B$15000,"")}
As can be seen above, I have two IFs which are comparing values in Column C and Column AT and returning values in Column B.
Always there shall be only one unique row in column B which shall satisfy the above two conditions.
Thus, I understand that the above formula will return an array of 15000 values in which there would be one value which is not null ("") and all other values shall be null ("").
However, I am not able to get that one value in Column B.
If I use MAX or SUM, I am able to get that value as follows :-
={SUM(IF(($C$11:$C$15000=C11)*($AT$11:$AT$15000-BM11<0.001),$B$11:$B$15000,""))}
But the value in Column B shall not necessarily be a number. It can be string also.
I have tried CONCATENATE but not getting any value.
How to achieve this ?
Bookmarks