<div>
Thank you much for your help.
</div>

<div>
<div class="content wysiwyg-content">
What I was trying accomplish is to have it look up a defined range in &nbsp;a column such as BS19:BS31 and it allowed me to do it but the formula I had did not function right. The original one I had written was just IF(BS19:BS33=”Y”,”Y”,”N”) was the idea. The problem with that formula was it only returned an answer for the first cell BS19. So I have it functioning the way I would like with it written out in the long form there, but I would like to try and keep things a little more concise than that if possible. 
 
=IF($BS$19=&quot;Y&quot;,&quot;Y&quot;,IF($BS$20=&quot;Y&quot;,&quot;Y&quot;,IF($BS$21=&quot;Y&quot;,&quot;Y&quot;,IF($BS$22=&quot;Y&quot;,&quot;Y&quot;,IF($BS$23=&quot;Y&quot;,&quot;Y&quot;,IF($BS$24=&quot;Y&quot;,&quot;Y&quot;,IF($BS$25=&quot;Y&quot;,&quot;Y&quot;,IF($BS$26=&quot;Y&quot;,&quot;Y&quot;,IF($BS$27=&quot;Y&quot;,&quot;Y&quot;,IF($BS$28=&quot;Y&quot;,&quot;Y&quot;,IF($BS$29=&quot;Y&quot;,&quot;Y&quot;, 
IF($BS$30=&quot;Y&quot;,&quot;Y&quot;,IF($BS$31=&quot;Y&quot;,&quot;Y&quot;,IF($BS$32=&quot;Y&quot;,&quot;Y&quot;,IF($BS$33=&quot;Y&quot;,&quot;Y&quot;,&quot;N&quot;))))))))))))))) 
 
Thank you for any help on this. 
 

</div>
</div>

What I was trying accomplish is to have it look up a defined range in  a column such as BS19:BS31 and it allowed me to do it but the formula I had did not function right. The original one I had written was just IF(BS19:BS33=”Y”,”Y”,”N”) was the idea. The problem with that formula was it only returned an answer for the first cell BS19. So I have it functioning the way I would like with it written out in the long form there, but I would like to try and keep things a little more concise than that if possible.

=IF($BS$19="Y","Y",IF($BS$20="Y","Y",IF($BS$21="Y","Y",IF($BS$22="Y","Y",IF($BS$23="Y","Y",IF($BS$24="Y","Y",IF($BS$25="Y","Y",IF($BS$26="Y","Y",IF($BS$27="Y","Y",IF($BS$28="Y","Y",IF($BS$29="Y","Y",
IF($BS$30="Y","Y",IF($BS$31="Y","Y",IF($BS$32="Y","Y",IF($BS$33="Y","Y","N")))))))))))))))

Thank you for any help on this.



Look up a defined range

What I was trying accomplish is to have it look up a defined range in  a column such as BS19:BS31 and it allowed me to do it but the formula I had did not function right. The original one I had written was just IF(BS19:BS33=”Y”,”Y”,”N”) was the idea. The problem with that formula was it only returned an answer for the first cell BS19. So I have it functioning the way I would like with it written out in the long form there, but I would like to try and keep things a little more concise than that if possible.

=IF($BS$19=&quot;Y&quot;,&quot;Y&quot;,IF($BS$20=&quot;Y&quot;,&quot;Y&quot;,IF($BS$21=&quot;Y&quot;,&quot;Y&quot;,IF($BS$22=&quot;Y&quot;,&quot;Y&quot;,IF($BS$23=&quot;Y&quot;,&quot;Y&quot;,IF($BS$24=&quot;Y&quot;,&quot;Y&quot;,IF($BS$25=&quot;Y&quot;,&quot;Y&quot;,IF($BS$26=&quot;Y&quot;,&quot;Y&quot;,IF($BS$27=&quot;Y&quot;,&quot;Y&quot;,IF($BS$28=&quot;Y&quot;,&quot;Y&quot;,IF($BS$29=&quot;Y&quot;,&quot;Y&quot;,
IF($BS$30=&quot;Y&quot;,&quot;Y&quot;,IF($BS$31=&quot;Y&quot;,&quot;Y&quot;,IF($BS$32=&quot;Y&quot;,&quot;Y&quot;,IF($BS$33=&quot;Y&quot;,&quot;Y&quot;,&quot;N&quot;)))))))))))))))

Thank you for any help on this.



Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.