|
Returning a Text Value
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 |
Returning a Text Value
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 |
Returning a Text Value
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 |
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 |
Returning a Text Value
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 |
Returning a Text Value
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 |
Returning a Text Value
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 |
Returning a Text Value
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 - |
| All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com