NESTED IFS PROBLEM

G-fer

Board Regular
Joined
Jul 18, 2005
Messages
192
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.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
In that case how about the MATCH function?

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

G-fer

Board Regular
Joined
Jul 18, 2005
Messages
192
WOW .....

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

Regards G-fer.
 

Watch MrExcel Video

Forum statistics

Threads
1,112,937
Messages
5,543,095
Members
410,583
Latest member
gazz57
Top