XLOOKUP Dynamic column can SAVE your life! Excel Mac & Windows
In this video, we will learn how to make the XLOOKUP dynamic column to return the results, It's always been a challenging and many subscribers, friends have asked me for how to make the XLOOKUP column dynamic which is similar doing VLOOKUP column number dynamic based on the column header. Solution is applicable Excel for mac and windows users. 00:00 Intro 00:22 Understanding the scenario 00:44 Understanding available data set 01:30 Solving the solution 06:29 End Screen -------------------------------------------------------------- Download File : https://excelexciting.com/how-to-return-xlookup-column-dynamically-in-excel-for-mac-and-windows/ -------------------------------------------------------------- 🛒 Affiliate links : - Support me with your Amazon purchases: https://amzn.to/3tR4AUN - Buy Office365: https://bit.ly/3nKcbnk 📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you. -------------------------------------------------------------- 🌎 https://www.ExcelExciting.com Connect to our forums feel free to ask queries & answer them https://excelexciting.com/forums/ -------------------------------------------------------------- Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/ -------------------------------------------------------------- 👍🏻 Like Facebook Page : https://www.facebook.com/ExcelExciting/ 👥Join The Facebook Group - https://www.facebook.com/groups/ExcelExciting/ *********************************************************** You can check the following videos as well *********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
In this video, we will learn how to make the XLOOKUP dynamic column to return the results, It's always been a challenging and many subscribers, friends have asked me for how to make the XLOOKUP column dynamic which is similar doing VLOOKUP column number dynamic based on the column header. Solution is applicable Excel for mac and windows users. 00:00 Intro 00:22 Understanding the scenario 00:44 Understanding available data set 01:30 Solving the solution 06:29 End Screen -------------------------------------------------------------- Download File : https://excelexciting.com/how-to-return-xlookup-column-dynamically-in-excel-for-mac-and-windows/ -------------------------------------------------------------- 🛒 Affiliate links : - Support me with your Amazon purchases: https://amzn.to/3tR4AUN - Buy Office365: https://bit.ly/3nKcbnk 📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you. -------------------------------------------------------------- 🌎 https://www.ExcelExciting.com Connect to our forums feel free to ask queries & answer them https://excelexciting.com/forums/ -------------------------------------------------------------- Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup https://www.meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/ -------------------------------------------------------------- 👍🏻 Like Facebook Page : https://www.facebook.com/ExcelExciting/ 👥Join The Facebook Group - https://www.facebook.com/groups/ExcelExciting/ *********************************************************** You can check the following videos as well *********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks