How to input a range in a logical test?

H

Help Me Rhonda TOA

When I input this formula: =IF(Q48=Protected!C27,+Q48,"") -- I get the
expected result,

but if I replace Protected!C27 with Protected!C27:C35,

I get # signs in the cell where my formula should be. What is the problem?"

Please respond to [email protected] --
 
S

Stan Scott

Do you want to find out whether Q48 matches any of the cells C27:C35?? If
you do, use the MATCH function. X=Range has no meaning in a formula.

Stan
 
Top