✅ Download the free course files to follow along ➡www.simonsezit.com/excel-dashboards-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Excel skill set with this free playlist 👉ru-vid.com/group/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
In what scenario would you use choose over xlookup .. I'm struggling to see the benefits of choose given you can't just use ranges so think I must be missing something?
The disadvantage of CHOOSE is that you have to hardcode the number of options in the function which usually is bad practice. I only use it whenever I know there will never be more options and I don't want an unsightly lookup table in my file, like for example when calculating the end of the quarter for any given date.
Thank you so much for your kind words! I'm glad you liked the video. 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
if you dont lock, and you drag the formula to update, it'll also move the referenced cell in the same direction, it'll not pick up from that cell, it'll pick up values from the one below/beside it depending on which direction you drag the formula. Lock will ensure your input is constant.