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
Watch video Google Sheets How to Use Xlookup in Multiple Columns online without registration, duration hours minute second in high quality. This video was added by user Eamonn Cottrell 30 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,867 once and liked it 32 people.