select from list

[apgmin]

In Column A1 to A500, I have address mentioned, In these the state is also mentioned
In column C1 to C50 I have the list of states

I want adjacent to Cell A1 that is in Cell B1 the state name from Cell A1 that will be picked from the list mentioned in List C1 to C50

Thank ytou in advance

 

[Jeffrey Mahoney]

Please try this

Book2
	A	B	C
1	2404 Jackman Street, Turqoise Nevada, 01234	Nevada	Alabama
2			Alaska
3			Arizona
4			Arkansas
5			California
6			Colorado
7			Connecticut
8			Delaware
Sheet1

Cell Formulas
Range	Formula
B1	B1	=LET(Ary,TEXTSPLIT(SUBSTITUTE(A1,",","")," "),Mtch,MATCH(1,COUNTIF($C$1:$C$50,Ary),0),INDEX(Ary,,Mtch))