I have a list of addresses in column A, List of states in Column D.

I would like to search the text in a cell, if it contains a certain state then return the state value based on the List.

Please see screenshot

Thank you in advance for the help!