Thread: Returning a Text Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default 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


Reply With QuoteReply With Quote