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.
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
| ID | Zipcode |
| 1234 | 10001 |
| 4321 | 10006 |
| 5243 |
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
| ID | Zipcode |
| 1234 | 10001 |
| 4321 | 10006 |
| 7541 | 10005 |
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
