wallyxl
Board Regular
- Joined
- Apr 24, 2011
- Messages
- 100
I know I can do this by nesting a load of if statements but I was wondering if there is an easier way.
If in cell A2 I have the value 12 and I want cell A1 to return a value FOUND if any cell from A6 to A24 has the value 12 in it.
Any quick fixes please?
If in cell A2 I have the value 12 and I want cell A1 to return a value FOUND if any cell from A6 to A24 has the value 12 in it.
Any quick fixes please?