Drop-down for States

		Microsoft Office Forums > Microsoft Excel > Excel
Drop-down for States

07-12-2023, 01:18 PM

Logit

Windows 10 Drop-down for States

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Another method ... (see attached)

Code:

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

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract States from a String	soldat452002	Excel	9	04-26-2018 04:16 AM
Drop down box list based on response to another drop down box	Phideaux	Excel	16	04-13-2018 03:07 AM
Drop down lists and pulling data from worksheet based on drop down selection	cjoyce73	Excel	5	07-17-2017 07:40 AM
How to import a map from mappoint 13 into PP 13 and then color fill individual states	rideninc	PowerPoint	0	01-22-2014 03:50 PM
Analysis of states and income levels	knownunknown	Excel	1	01-22-2011 06:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:38 PM.