I figured it out. here is a cut and paste of the formula.
I know that I have one CARRIER and it will only operate in one REGION so I tested it and it worked. Well it worked from CARRIER to REGION.
When I tried for COUNTRY IRONSPEED yet again realizes that this is a field for COUNTRY so it thinks it is doing me aa faavor by populating ALL countries.
How can I turn this off?
The REGION I am Referring to is North America yet it overrides that and populates with all countries.
How can I turn this off ?