using an if statement to reference a collumn

[burnsa9]

Hello, I am trying to create a large loop that will reference my column called cities. I want the loop to refernce cities and put the state of these locations in a new column with the header state. My table is below. I have 5 different cities Memphis, Sand Diego, Seatle, Portland, and Charlotte.
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]Market [/TD]
[TD]Day of the week [/TD]
[TD]Country [/TD]
[TD]State[/TD]
[/TR]
[TR]
[TD]Memphis [/TD]
[TD]Sunday [/TD]
[TD]United states [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]San Diego [/TD]
[TD]Saturday [/TD]
[TD]United States [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Seatle [/TD]
[TD]Monday [/TD]
[TD]United states [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

You can use a VLOOKUP where A2 has the city and H1:I3 has the city and state list.

=VLOOKUP(A2,$H$1:$I$3,2,0)

If you do not want to have the list off to the side you can put it into the vlookup like this

=VLOOKUP(A2,{"Memphis","TN";"San Diego","CA";"Seatle","WA"},2,0)

 

[burnsa9]

State isn't given, I am trying to populate the column

 

[Scott T]

The formula gives the state. it looks up the city and returns the state form the list.