Microsoft Excel - XLOOKUP Video Case Study
We love Microsoft Office 365! If you love VLOOKUP you will love XLOOKUP even more! Microsoft has added some some awesome functionality with the release of Excel 2019 that you may have not had a chance to test yet.
It is a huge time saver and it has a cleaner feel as you don't have to build in a separate error check. If you never used VLOOKUP you will find this easier to learn too!
Since it is much easier to learn a function by by reviewing a scenario you can apply to a real project we put together a sample workbook.
The example in the video walks you through how to set up a Budget 2021 preparation worksheet by site location. It includes estimated contract totals for 2020 and the estimated annual budget for 2021.
DOWNLOAD:
LINKS:
Excel XLOOKUP
https://exceljet.net/excel-functions/excel-xlookup-function
Script Font - Summer Festival
https://creativemarket.com/WornOutMedia/1458519-Summer-Festival-Typeface
What's Kajabi? - The best kept secret that Multifamily does't know about yet! Reach-out today to find out more! 🙂