Microsoft Office Forums - View Single Post - Drop-down for States

Thread: Drop-down for States

View Single Post

Old

07-12-2023, 01:18 PM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 533

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

Another method ... (see attached)

Code:

=IF(A1="Alabama - AL","AL",IF(A1="Florida - FL","FL",IF(A1="Washington - WA","WA","")))

Attached Files

States Selection and Abbreviation.xlsm (8.8 KB, 5 views)

Reply With Quote