The XLookup overcomes the limitations of the Vlookup Function in Microsoft Excel Spreadsheets. With the XLookup you are not bound by the lookup value being located in the first column of the table, you can return the nearest highest value and more. 

YouTube Analir Pisani https://youtu.be/II3XXd2uNZ8
Customised Computer Courses in Sydney, Australia and Virtual Classes. http:www.azsolutions.com.au

🎓
Offer Microsoft Office Training: Virtual and F2F Sydney, NSW
http://www.azsolutions.com.au

Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545

Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/

Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749

For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/

Virtual Classes or join me face to face in Sydney NSW Australia.
https://azsolutions.com.au/virtual/

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist