Returning a Text Value
What if you copy the formula to the first cell say BO2 and copy down to row
31..not as an array formula ** enter normally**
=IF($BN$2:$BN$31=1,$A$2:$A$31,"")
--If you select all cells in the range BO2:BO31 then Ctrl+Enter
If this post helps click Yes
---------------
Jacob Skaria
"bob" wrote:
Sorry but this formula returns a blanks cell. No error, just a blank cell
"Jacob Skaria" wrote:
Try this formula
=IF($BN$2:$BN$31=1,$A$2:$A$31,"")
'To apply to all cells in one stretch
--Copy the above formula as text to clipboard
--Select the range say BO2:BO31.
--Press F2. and paste teh formula to the active cell
--Press Ctrl+Shift+Enter
If this post helps click Yes
---------------
Jacob Skaria
"bob" wrote:
This is a array formula. If BN2:BN31 = 1, then display the corresponding
value from the same row in column A. Column A contains all text values
I have tried this without success: {IF($BN$2:$BN$31=1,$A$2:$A$31,))}
Can anyone help? Thanks.
Bob
|