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.
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.