Go offline with the Player FM app!
XLOOKUP and Data Sets in Google Sheets and Excel
Manage episode 355069348 series 3018946
Hi there! We are using LOOKUP functions in Google Sheets and Excel this week! We're focused on the XLOOKUP in the pod, but all are explained in the video linked below π
Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? π I'm hoping to grow this to 1000 subscribers this year!
Episode Overview:
Walking through the functionality of the XLOOKUP function in both Excel and Google Sheets. XLOOKUP was added by Microsoft in 2019 as a successor to VLOOKUP and HLOOKUP. Google Sheets added it in 2022. It combines the best features of VLOOKUP and HLOOKUP, and is able to be used as either a vertical or horizontal lookup function itself. It's become my favorite way to lookup data. What about you?
The links to my video walkthrough and the Google Sheet we're using are available below.
Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!
Resources mentioned:
- Video Walkthrough for XLOOKUP and More
- Example Google Sheet with the Code
- In depth article
- Find me on my site
- Watch me on YouTube @eamonncottrell
- Follow me on Linkedin @EamonnCottrell
- Buy me a coffee on BuyMeACoffee
- Laugh at me on gitHub @sieis
35 episodes
Manage episode 355069348 series 3018946
Hi there! We are using LOOKUP functions in Google Sheets and Excel this week! We're focused on the XLOOKUP in the pod, but all are explained in the video linked below π
Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? π I'm hoping to grow this to 1000 subscribers this year!
Episode Overview:
Walking through the functionality of the XLOOKUP function in both Excel and Google Sheets. XLOOKUP was added by Microsoft in 2019 as a successor to VLOOKUP and HLOOKUP. Google Sheets added it in 2022. It combines the best features of VLOOKUP and HLOOKUP, and is able to be used as either a vertical or horizontal lookup function itself. It's become my favorite way to lookup data. What about you?
The links to my video walkthrough and the Google Sheet we're using are available below.
Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!
Resources mentioned:
- Video Walkthrough for XLOOKUP and More
- Example Google Sheet with the Code
- In depth article
- Find me on my site
- Watch me on YouTube @eamonncottrell
- Follow me on Linkedin @EamonnCottrell
- Buy me a coffee on BuyMeACoffee
- Laugh at me on gitHub @sieis
35 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.