How to compare 2 excel databases

Hi everybody, I have two databases on 2 separated excel sheets. The first one contains a Dataserie related to alarms composed by Tag number (containing the Equipement Reference) like 123EQUIPA-001, the Alarm Type, hour, ect. The second one contains the list of 1340 critical equipment ( EQUIPA EQUIPB, ....) I'm trying to filter from the fist Database the liste of Alarms related to critical Equipment. Any Idea how I should proceed, Thank you in advance, KB

• › How to compare 2 text columns in Excel & flag the odd ones?
• › [Solved] need app to compare 2 excel files & report all differences
• › [Solved] how to repair damage excel file
• › How to create a excel Fn to select a range?
• › Visual basic Code needed to compare the excel
• › how to compare cells in excel
• › [Solved] Excel 2007 - Compare 2 columns using conditional formatting