video1.0<iframe src="https://www.loom.com/embed/62c7ac42186c4d06bb7ad8821fd15a11" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/62c7ac42186c4d06bb7ad8821fd15a11-523b4c712392c9a2.gif254.270683In this tutorial, we'll show you how to use the xlookup functionality within your workbook to seamlessly integrate additional data sets, such as forecast and budget information, into your existing queries. Building on our previous example of portfolio performance by stay month, you'll learn how to add a new data tab for forecasts and budgets, utilize AI-assisted tools to populate the necessary fields, and ensure consistency by aligning stay periods across datasets. We'll guide you through combining these data sets into a single comprehensive table using xlookup, enabling you to reconcile and analyze your portfolio’s performance effectively. Additionally, we'll demonstrate how to verify the accuracy of your merged data and format it for clarity, ensuring your analysis is both reliable and easy to understand. By the end of this video, you'll be equipped to enhance your queries with multiple data sources, providing a more complete overview of your portfolio's performance.