Hi everyone,

I am looking for enhancing a bit a named range.

In a workbook, I am using a combo box for interactive charts and tables.

In fact, you select your country in a combox. Thanks to a VLOOKUP fonction, the named range SelectedCountry takes the value of the country name. This SelectedCountry range is then used in several charts and tables calculation (eg =SUMPRODUCT((A1:A1000=SelectedCountry)*B1:B1000... if column A is where countries are reported and B figures)

For the moment, it works fine. One of my problem is that I would like to merge results of two countries to allow giving data for a supra-entity, that is to say :
Supracountry = Country A + Country B

In the combobox, you would have the choice between:
CountryA
CountryB
SupraCountry
CountryC
...

As an illustration, think to Canada and the USA, if I wanted to represent North America.

Thus, I would like SelectedCountry to take the value "CountryA"OR"CountryB" when SupraCountry is selected. But the OR function does not seem to respond to that need...

Do you have an idea ? Am I enough clear ?

Thanks in advance !