NESTED IFS PROBLEM

[G-fer]

Hi ...

I've a nested IF problem.

Cells G9 to G18 each contain a number.

There is a number in cell B5.

In B7 I want to say "Yes" if the number in B5 matches any of the numbers in G9:G18.

Nested IFs won't work because of the 7 max. rule.

Any ideas??

G-fer.

 

[onlyadrafter]

Hello

try

=IF(ISERROR(MATCH(B5,G9:G18,0)),"","YES")

 

[agihcam]

try;

=IF(COUNTIF(G9:G18,B5)>0,"Yes","")

 

[GlennUK]

In that case how about the MATCH function?

Like:

=IF(ISNA(MATCH(B5,G9:G18,0)),"No","Yes")

 

[G-fer]

WOW .....

Thanx team ... one of them will fix it.

Regards G-fer.