=IF(SelectCountry=France,FranceBoats)
=IF(SelectCountry=Greece,GreeceBoats)
The desired effect is when selectCountry is France the options available in the list box are franceBoats but if selectCountry is Greece then the options available are Greeceboats. The equations above work as stand alones but how do I put them together in one equation?
It will be frustrating and disappointing if there is a such a short sighted limitation like this that does not allow the combination of such equations for one list box source.
Thanks.