Re: Is this possible? If so what function do I use?
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Mon, 10 Sep 2007 11:09:00 -0300
Great list available here:
http://www.usps.com/ncsc/lookups/abbr_state.txt
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"T. Valko" <biffinpitt@xxxxxxxxxxx> wrote in message
news:evY37L78HHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
Create a 1 column table of all 50 states. Assume this table is in the
range D1:D50.
Then, in column B:
=IF(COUNTIF(D$1:D$50,A1),"United States","")
Copy down as needed.
--
Biff
Microsoft Excel MVP
"AdirondackSam" <AdirondackSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F9F73262-525A-41E5-86C2-E056A35979E4@xxxxxxxxxxxxxxxx
My data is:
A B C
TX United States
MA
NY United States
NJ
NH United States
London United Kingdom
Paris France
Column A has states that are almost always populated, but B is often left
blank. I wanted to create some type of Array or Lookup that has all the
states in it, and them do a comparison; If what is in Column A is a
valid
state, then populate B with "United States, otherwise leave it alone.
I can't use "IF" because there are too many arguments, and can't figure
out
how to make it work with something like VLOOKUP.
Advice apreciated.
~S
.
- References:
- Re: Is this possible? If so what function do I use?
- From: T. Valko
- Re: Is this possible? If so what function do I use?
- Prev by Date: Re: MATCH() on a 2D array?
- Next by Date: Re: MATCH() on a 2D array?
- Previous by thread: Re: Is this possible? If so what function do I use?
- Next by thread: Re: Is this possible? If so what function do I use?
- Index(es):
Relevant Pages
|
