Multi if Macro or VB code to fill fields based off a column reference?

[NGB82KS]

OK, I've got a spreadsheet with students from all 50 states.
What i'm trying to do is write a macro or a function that checks cell "I" of Table name "ADU" and fills in the state based of a table or code, if that makes sense??
In my Example below, it would lookup the student in row 2, check column I, see the field is BRONX, and would therefore fill in column J with New York.
Anyone know how i could accomplish this? I have to repeat this each month, and doing it all by hand seems...uh.. tedious for 10K plus students.
(Example)

	A	B	C	D	E	F	G	H	I	J
1​	DISPLAYNAME	SURNAME	FIRSTNAME	MI	GEN	STUID	CODE	ROLE	City	STATE
2​	DOE.JOHN.C	DOE	JOHN	C		1234567890​	A	STU	BRONX

 

[Fluff]

Do you have a table with all the cities in one column & their states in another?

 

[NGB82KS]

Do you have a table with all the cities in one column & their states in another?

I'm still building that but yes, on another tab called lookup, but i stopped because i wasn't sure if a Macro would be better or a table

 

[Fluff]

In that case you can just use a vlookup formula, like
=vlookup(I2,lookup!A$2:B$100,2,0)

 

[NGB82KS]

In that case you can just use a vlookup formula, like
=vlookup(I2,lookup!A$2:B$100,2,0)

Didn't work, but think that's my table maybe, It looks like this

	A	B	C
1	REGION CODE	STATE	CITY
2	REGION 1	NEW YORK	BRONX

 

[Fluff]

Ok, in that case use
=index(lookup!B$2:B$100,match(I2,lookup!C$2:C$100,0))

 

[NGB82KS]

Ok, in that case use
=index(lookup!B$2:B$100,match(I2,lookup!C$2:C$100,0))

Ok, last one i promise.... It filled in all the states with 1 word but not the two word states. "New York" gives me a #N/A, whereas Ohio gives me Ohio. I tried adding quotes around it but that didnt work. Im trying to look at a google search for exact reference with 2 words while im typing this out as well.

 

[NGB82KS]

Ok, in that case use
=index(lookup!B$2:B$100,match(I2,lookup!C$2:C$100,0))

Nevermind, i got it... Thanks!

 

[Fluff]

It doesn't matter how many words there are, just as long as the value in I2 is found in col C of the lookup sheet.