States being approved

[twiley23]

Hi all im creating a chart for the 50 US states, what i would like to do is have some states match up and others wont, example , CA to NY is fine but NY to CA is bad , CA to AZ is fine and AZ to CA is fine the NY to AZ is bad and AZ to NY is bad

 

[alansidman]

Explain your criteria for good and bad. Also demonstrate your layout with a few records so we understand completely. Will all states have a good/bad relationship with all other states.

 

[jtakw]

Didn't you already asked here: https://www.mrexcel.com/forum/excel...sure-formula-use-post5170897.html#post5170897

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).