Choosing a specific value from list, turning off other formulas

[KIrsch]

Here's the situation:

I have a list of countries where I'm selling widgets. Each country has
an associated forumla that takes the overall country population (my
input) and, based on a few variables, provides a total addressable
market (my output).

When a new widget is ready, it's typically only available for one or
two of those countries, but not all. Is there a formula that will
alllow me to enter the country (ie "US", "UK") where the widget is
available, so that I can that country's formula, while "shutting off"
all of the others?

thanks in advance...

 

[JE McGimpsey]

Here's the situation:

I have a list of countries where I'm selling widgets. Each country has
an associated forumla that takes the overall country population (my
input) and, based on a few variables, provides a total addressable
market (my output).

When a new widget is ready, it's typically only available for one or
two of those countries, but not all. Is there a formula that will
alllow me to enter the country (ie "US", "UK") where the widget is
available, so that I can that country's formula, while "shutting off"
all of the others?

I'm sure you know exactly what you're after, but it's not at all clear
to me, so this may or may not help.

One method may be to create a table, perhaps on another sheet, a lookup
table that matches widgets to countries:

A B C D
1 Country Widget1 Widget2 Widget3
2 US 1 1
3 UK 1 1 1
4 FR 1 1
....

Then your current formulae could wrap a check around them, i.e.:

=IF(ISNA(VLOOKUP(A2,Sheet2!A,3,FALSE)),"",<your current formula
here>)

Where A2 contains your country code, and 3 would be used for Widget2.

If this makes no sense to you, reply with a more complete description of
your data layout and formulae.