-In 1 worksheet I have a list of contacts with adress, city, zip in Columns D, E, F respectively. I'd like to fill column G with the state.
-In worksheet 2 I have a list of all US zip codes in column A and the corresponding State in Column B.
-How do I write a formula to reference Column F look for the matching zip in column A of worksheet 2, find the corresponding state in the adjacent column, and insert that state in column G on worksheet 1?

I imagine this is simple, but am obviously a beginner.