VLOOKUP Help with importing city and state from list when entering zip code

[wpsatisfide]

sheet 1 I add addresses daily to and I am looking for a way to pull in the state and city after I enter the zip code
Sheet 2 has a list of all zip codes, cities, and state in A1, B1, C1 to A1129, B1129, C1129
I know it uses VLOOKUP but not sure how to set it up

Thanks in advance

[wpsatisfide]

Thank you so much. You have saved me massive amounts of time

[Villeroy]

City =VLOOKUP(X1;$A$1:$C$1129;2;0) with zip code in X1.
State =VLOOKUP(X1;$A$1:$C$1129;3;0)

[LeroyG]

=VLOOKUP(X1;Sheet2.$A$1:…