This Excel tutorial will teach you my favorite function: XLOOKUP. We will use it efficiently by looking for tables and table columns instead of spreadsheets and cell ranges. We will also do some exercise to strengthen your XLOOKUP skill. Enjoy!
📚FOLLOW ALONG! LINK WITH THE WORKBOOK:
https://www.dropbox.com/scl/fo/dp3idgdx5g5u598vso56z/h?rlkey=e9kk9tmcrf8dcas6ba9nxo20t&dl=0
🕓TIMESTAMPS:
00:00 Introduction
00:58 Preparing tables
02:28 Introduction to XLOOKUP
05:22 Exercising XLOOKUP
06:42 Mathematical operations with XLOOKUP
09:02 XLOOKUP multiple return arrays
11:34 Handling N/A Error
12:38 More Mathematical operations with XLOOKUP
15:05 XLOOKUP with multiple conditions.
18:05 Wrap up
💻RELATED VIDEOS:
- Playlist with all my videos on Power Query: https://youtube.com/playlist?list=PL2-FQQ5rWXBom-pX9Pg3uPnHOrd5QBJ72&si=XvwrGJCnchjTfdRR
