{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/e9991379877746b29dacc9425dc6df4d\" 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/e9991379877746b29dacc9425dc6df4d-7ab12aafa1287e09.gif","duration":446.644,"title":"Comparing Files using XLOOKUP - Google Sheets","description":"In this video, I walk you through how to compare two sets of data in Google Sheets using XLOOKUP. I demonstrate the process of pulling monthly costs from an open enrollment file to a current elections file, ensuring that each employee is listed only once. I also show how to identify employees who are not on the current elections file. Please make sure to follow along and try this out with your own data!"}