Combining INDIRECT
Sorry, I missed the hidden CF bit.
--
__________________________________
HTH
Bob
"Ken" wrote in message
...
Thanks to all....
I still get the "formula contains an error" with OR instead of AND,
and Bob's formula gives me "cannot use unions, intersects, or array
constants..." etc. I'm using Excel 2007, if that's a problem. It looks
like either of the formulas should work, but still getting
errors....Thanks for any and all help!
Ken
|