Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)

Ever wondered which lookup formula to use given a situation? Me too. So I asked Oz to tell me how to get lookups right. In this informative interview, Oz talks about:

1) When to use VLOOKUP
2) When to use XLOOKUP
3) When to avoid lookup formulas and use DA functions like FILTER()
4) When to use Power Query

We will be looking at 5 most common scenarios for lookups in business data situations and analysing them.

These are
1) Simple lookups
2) Lookup from a column in the middle
3) Two way lookup
4) Lookup based on multiple conditions
5) Lookup and return all matching results

Video topics:

0:00 - Introduction
1:23 - Oz on stage
4:24 - A quick look at the data and five scenarios
5:31 - Simple lookup
7:18 - Lookup in the middle - based on a column not on left
9:51 - Two way lookup (both column and row based conditions)
12:09 - Multiple conditions in lookups
15:22 - Multiple matching results with lookup formulas
17:45 - Power Query for getting multiple results or multiple conditions
20:00 - Closing remarks on what attitude we need to have to build necessary data skills

Links & Resources:
===============

Workbook from the video:
https://chandoo.org/wp/wp-content/uploads/2020/07/best-lookups-with-oz.xlsx
Oz's Excel on Fire Channel - https://www.youtube.com/user/WalrusCandy
Chris Penn's article mentioned by Oz - https://www.christopherspenn.com/2017/05/avoid-magic-for-magicians-marketing-for-marketers/

#MsExcel #VLOOKUP #XLOOKUP

Sound effects from zapsplat.com

Видео Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire) канала Chandoo