finding a number within a range within an if statement -


i attempting create if statement use contents of cell (a1) within range (g2:g11), if found show word "multi", otherwise blank "".

the formula attempting use =if(a2=g2:g11,"multi",""). can find first number within range, no other number within range when tested it. appreciated. in advance.

a simple countif it:

=if(countif(g2:g11,a1),"multi","") 

Comments