video1.0<iframe src="https://www.loom.com/embed/990d10f9c8604fb2b6ab21948c4b4073" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/990d10f9c8604fb2b6ab21948c4b4073-deb7f4afb5b902a7.gif396.476In this video, I walk you through how to effectively compare two different files in Excel using the XLOOKUP function. I demonstrate how to pull data from an open enrollment elections file into a current elections file to identify any differences in employee costs. I also highlight the importance of using unique identifiers like social security numbers for accuracy. Please make sure to follow along and try this method with your own files!