G
Guest
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
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