Using an excel membership number list to compile a civi report of linked addresses
If the "membership number" corresponds to the CiviCRM Contact ID, or to the External Identifier field, you can use Contacts menu » Import Contacts to import JUST the membership number.  On the final field of the import, use the option to create a new Group of the imported records.  Since all of the corresponding members exist in CiviCRM, this won't do anything except add everyone in your spreadsheet to the group.

Then you can do a Search for that Group, then do an export of the required fields.