Google Sheets How to Use Xlookup in Multiple Columns
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/
🤔 How do you use XLOOKUP if you have a table with multiple columns to search through? I'll walk you through two methods.
The first one is thanks to a video Oz did yesterday on his channel for Excel, but it doesn't work 100% in Google Sheets, so I wanted to give an alternative approach.
Check out Excel on Fire for some Excel wizardry, and hope this is helpful for you!
🙌Oz's video: • Retrieve the Adjacent Value from a Gr...
⚒️The Google Sheet I used: https://docs.google.com/spreadsheets/...
=============================
🙏Want to say thanks? Subscribe to the channel; I love making these videos:
https://www.youtube.com/@eamonncottre...
💰Want to say thanks with 💲? You're awesome! Buy me a coffee:
https://bmc.link/W4V7SRM
💌Weekly newsletter: https://got-sheet.beehiiv.com/subscribe
►You can find more of my work including articles and podcasts on my website at https://www.eamonncottrell.com/
=============================
⌚Chapter Time Markers:
00:00:00 - Intro
00:00:58 - OFFSET Solution
00:01:57 - Problem with OFFSET
00:02:49 - XLOOKUP Solution
=============================
#googlesheets #sprr
