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

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

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

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

Sorry, but that returns the same result.

"Jacob Skaria" wrote:

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

What do you have in colA.Try entering dummy values to A1:A5 as in the below
table..and apply the formula to cell c1...the result should be as below...

=IF($B$1:$B$5=1,$A$1:$A$5,)

Col A Col B Col C
aa 1 aa
bb 2 0
cc 1 cc
dd 2 0
ee 1 ee



If this post helps click Yes
---------------
Jacob Skaria


"bob" wrote:

Sorry, but that returns the same result.

"Jacob Skaria" wrote:

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

in BO2:

=IF(BN2=1,OFFSET(BN2,0,-65))

then copy down

On 6 Lis, 02:06, 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

or

=IF(BN2=1,A2)


On 6 Lis, 13:16, Jarek Kujawa wrote:
in BO2:

=IF(BN2=1,OFFSET(BN2,0,-65))

then copy down

On 6 Lis, 02:06, 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- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -