Match Data From Two Sheets

[MRovi]

I have two sheets of data. Sheet 1 has ID's and sheet 2 has ID'sand zip codes. I need to match the zip codes to the first sheet if there is a matching ID. The two sheetsonly have some matching ID's so I can't just sort them.

[TABLE="width: 128"]
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]ID[/TD]
[TD="width: 64, bgcolor: transparent"]Zipcode[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1234[/TD]
[TD="bgcolor: transparent, align: right"]10001[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4321[/TD]
[TD="bgcolor: transparent, align: right"]10006[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5243[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 128"]
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]ID[/TD]
[TD="width: 64, bgcolor: transparent"]Zipcode[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1234[/TD]
[TD="bgcolor: transparent, align: right"]10001[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4321[/TD]
[TD="bgcolor: transparent, align: right"]10006[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7541[/TD]
[TD="bgcolor: transparent, align: right"]10005[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Use a VLOOKUP function.

See: https://exceljet.net/formula/vlookup-from-another-sheet