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
|