Maybe an array is needed?
Morning,
I have eight cells that return a text message if certain conditions are met.
Those eight cells have a named range, Range_1. Currently the formula I have
tests just one cell for that string; =IF(G20=msg, "XXX", ""). I would like
to enhance this formula to test if any of the cells in Range_1 result in that
string (a named range msg), and if so display a more detailed message now
€œXXX€, elsewhere. I am trying to work through an array, currently
unsuccessfully.
Sincerely,
Arturo
|