Filtering attributes in a shapefile using a common ID from an Excel file

If you can connect the shapefile with Excel file using join by attribute, then you can simply save the joined file as a new shapefile and the link will exist permanently.

In this case, Rev field which exist in Excel file will be written / transferred to shapefile and you can filter the new shapefile by Rev field.

You can temporary join table to your shapefile via Joins tab in layer properties.

1. save your table as .csv
2. load the CSV using Add Delimited Text Layer...
3. go to Joins tab in shapefile layer properites, and hit the + button
4. make a join by setting your id

Done, the CSV values append to your shapefile remaining in CSV (not writing to shapefile). You can also edit the CSV values in external spreadsheet editor (Calc, Excel, etc.). When you remove the CSV from your QGIS project, the connection (attributes from shapefile) is also removed.

The only faster way of doing this beyond the other answers is to automate it using python/pyqgis (creating the join, iterating through the join layer and looking for successfully joined features, and commuting the attribute edit). Here's a tutorial on the joining part.

https://www.qgistutorials.com/en/docs/performing_table_joins_pyqgis.html

The other parts you should be able to find more code examples by using various keyword searches like "pyqgis commit edit" or "pyqgis get layer features".