video1.0<iframe src="https://www.loom.com/embed/121d8861cc924017a3aed9184053b34d" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/121d8861cc924017a3aed9184053b34d-fd1a1a9b661948d4.gif140.322In this video, I demonstrate how to create a lookup in ECO to transfer data from one table to another, similar to the VLOOKUP function in Excel. I specifically show how to map the contact ID from the sales orders table to retrieve the full name from the contacts table. I also discuss additional options for filtering results and returning multiple fields in one lookup.