Match value in sheet1 for sheet2 and copy to sheet2

[soli004]

Hello forum!
I have a large file + 400 000 rows that has zip code but not city name in sheet2, in sheet1 I have a list of zip code and city name. I need to get the correct city name for the zip code in sheet2 by using the info from sheet1. I attached a file as an example how it looks. I do have lots of other data in the original files that I have removed. This is not doable manually by using filter, to many rows so I need a script to run it.

Thankful for any help resolving this.

[AB33]

Formula in B2 and drag it down

Please Login or Register  to view this content.

[soli004]

AB33 EXELLENT!!

Worked perfect! Thank you!