{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/990d10f9c8604fb2b6ab21948c4b4073\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/990d10f9c8604fb2b6ab21948c4b4073-deb7f4afb5b902a7.gif","duration":396.476,"title":"Comparing Files Using XLOOKUP - Excel","description":"In 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!"}