A while back excelliot helped me with the following formula...I'll just paste the formula verbatim:

=IF(COUNTIF(Sheet1!A:A,"myvalue122")>0,"myvalue122",IF(COUNTIF(Sheet1!A:A,"myvalue123")>0,"myvalue1

The data would theoretically contain only one of the three, however, in some cases, NONE of the three would be there, and instead some number of variations would occur (darn!). Despite the tedious nature of it, I would like to add in every other option that could be present IF those three were not it. In this case there could be more than one variation.

Put another way, I might have, instead of the "Easy Button" choices above,

one of these:
Mydata454(B;B)
Mydata454(B;C)
Mydata454(C;C)

as well as one of these:
Mydata455(D;D)
Mydata455(D;E)
Mydata455(E;E)

and so on.

I would like to append the formula to say, "if the previous choices aren't found, add all of these others that apply".

Thanks for any help!

Suzanne