need to add an OR statement if the first three choices aren't validated

[SLBELL]

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

[TMS]

You haven't included all the formula but I would guess all you need is another COUNTIF for the third condition.

For a specific tested solution, I would suggest that you post a sample workbook with some typical data identifying the expected solution for each option.


Regards, TMS

[FDibbins]

Or perhaps a vlookup() into a table?

upload your samplwe WB, and we can see what you need