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

Thread: Drop-down for States

View Single Post

Old

07-16-2023, 06:36 PM

Karen615

Karen615 is offline

Karen615 uses Windows 11

Windows 11 Karen615 uses Office 2021

Karen615 uses Office 2021

Office 2021

Competent Performer

The original poster

Join Date: Jun 2011

Location: Chicago

Posts: 145

Karen615 is on a distinguished road

Default

Quote:

Originally Posted by Logit

View Post

Another method ... (see attached)

Code:

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

Thank you so much! I'll check it out and see if I can get it to work for me.

Reply With Quote