{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/01053afb8ab948f2a68ea1ca2cdac2d3\" frameborder=\"0\" width=\"1466\" height=\"1099\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1099,"width":1466,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1099,"thumbnail_width":1466,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/01053afb8ab948f2a68ea1ca2cdac2d3-1705513755502.gif","duration":290.8,"title":"Using VLOOKUP to Find Contact IDs in Google Sheets","description":"In this video, I will guide you through using the VLOOKUP formula in Google Sheets to find contact IDs associated with donors during a transaction import. I will explain the steps to export your contacts to CSV, rename the file, and set up the necessary columns. Then, I will demonstrate how to merge names using a join formula and show you how to use the VLOOKUP formula to match contact IDs with full names. By the end of the video, you will be able to efficiently find contact IDs for your donors."}