Hi Adam! To set up a vlookup, you would use the Lookup Record in Other Table integration, which can return columns even if they don't have any data. If you need to pivot data between tables, the lookup single rows enrichment column is the best solution, and there's a video tutorial that shows how to set this up for your specific use case. If your vlookup needs to pull multiple matching records from another table, you should use the Lookup Multiple Rows in Other Table enrichment, which works similarly to the single row lookup. Here are the tutorial links provided in the sources:
* Write-to-Table Integration: Examples and Use Cases
* Setting up Lookup Column in Context
* Lookup Multiple Rows in Other Table Tutorial
If there's anything else I can assist you with, please let me know! 😊
Have a great Friday,
Daniel