Part 4.3 of Google Sheets 101!
The last lookup function we will look at (pun intended) is XLOOKUP, or Cross (X) lookup! This one does everything the previous two do, and more! It just makes sense to use it! While there is more to learn within it, there is more you can do!
Timestamps:
00:00 Introduction
01:07 Lookup Functions Review
01:52 XLOOKUP Function
08:53 Cell Referencing
11:44 TRANSPOSE Function
14:05 XLOOKUP Arguments
19:51 Conclusion
20:54 End slides
--
Links:
Here are the resources for these videos! Feel free to follow along with the Spreadsheet below, review the Hotkey (keyboard shortcuts) I used in the videos, or pick the "darkmode" or regular Function List below!:
Spreadsheet:
docs.google.com/spreadsheets/...
Hotkeys Table:
docs.google.com/spreadsheets/...
"Darkmode" Function List Document:
docs.google.com/document/d/1j...
Function List Document:
docs.google.com/document/d/12...
-
Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN www.linkedin.com/in/matthew-k...
Song: "Grit Groove" By Ambiosynthesis
• Grid Groove
Негізгі бет XLOOKUP Function (use this instead of VLOOKUP or HLOOKUP!)
Пікірлер