Peterwolf4422

asked on

# 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="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.

=IF($BS$19="Y","Y",IF($BS$

IF($BS$30="Y","Y",IF($BS$3

Thank you for any help on this.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER