Quick Summary: get all instances of a specific family type , get the Owner View, get a parameter from the Owner View, use that parameter to lookup another value in an Excel sheet, then drive an instance parameter back into the family instances based on the Excel lookup.
Source: What Revit Wants