How can I create a new column that lists the state based on the city already provided? Corresponding states for each city are listed in a separate tab from the rest of the data

I need to add a column to the first sheet that links back to the state sheet