Instead of using Nested IF, use LOOKUP and XLOOKUP

  Рет қаралды 797

Profectus Academy

Profectus Academy

Күн бұрын

In this video, you will learn the powerful Lookup() and Xlookup() functions and replace layers of Nested IF. You will learn how to use the approximate match option in Vlookup to do the same.
You will also learn to create Vector operations with these.

Пікірлер: 1
@newari1111
@newari1111 2 жыл бұрын
This has saved so much of my time!
How to compute YTD numbers in MS Excel? | 3 ways to get Year to Date Sales in MS Excel
4:31
How to compute YTD numbers in MS Excel? | 3 ways to get Year to Date Sales in MS Excel
Profectus Academy
Рет қаралды 36 М.
Trim function not working? No-break space could be the reason
5:48
Trim function not working? No-break space could be the reason
Profectus Academy
Рет қаралды 8 М.
Synyptas 4 | Кәріс районның абыройын құртты !
20:38
Synyptas 4 | Кәріс районның абыройын құртты !
kak budto
Рет қаралды 1,4 МЛН
Please Help This Poor Boy 🙏
00:40
Please Help This Poor Boy 🙏
Alan Chikin Chow
Рет қаралды 23 МЛН
КАК АСЕТ НАУРЫЗБАЕВ ЗАРУБИЛСЯ С ДЕПУТАТОМ ЕРЛАНОМ СТАМБЕКОВЫМ #аэс #стамбеков #гиперборей
00:53
КАК АСЕТ НАУРЫЗБАЕВ ЗАРУБИЛСЯ С ДЕПУТАТОМ ЕРЛАНОМ СТАМБЕКОВЫМ #аэс #стамбеков #гиперборей
ГИПЕРБОРЕЙ
Рет қаралды 602 М.
Ozoda - Lada ( Official Music Video 2024 )
06:07
Ozoda - Lada ( Official Music Video 2024 )
Ozoda
Рет қаралды 18 МЛН
How to connect slicer to waterfall charts in MS Excel?
7:49
How to connect slicer to waterfall charts in MS Excel?
Profectus Academy
Рет қаралды 8 М.
How to automatically add numbering to text in a single cell in MS Excel?
6:33
How to automatically add numbering to text in a single cell in MS Excel?
Profectus Academy
Рет қаралды 6 М.
How to repeat set of values varying number of times in MS Excel
5:28
How to repeat set of values varying number of times in MS Excel
Profectus Academy
Рет қаралды 1,2 М.
How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars
10:26
How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars
Profectus Academy
Рет қаралды 9 М.
How to model depreciation under straight line method?
9:18
How to model depreciation under straight line method?
Profectus Academy
Рет қаралды 379
Is AI alignment even necessary? Some thoughts on OpenAI's uncensored internal CoT approach
20:09
Is AI alignment even necessary? Some thoughts on OpenAI's uncensored internal CoT approach
David Shapiro
Рет қаралды 2,9 М.
Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative
5:19
Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative
Profectus Academy
Рет қаралды 1,7 М.
Negative Time is Real, Physicists Confirm. Kind Of.
6:59
Negative Time is Real, Physicists Confirm. Kind Of.
Sabine Hossenfelder
Рет қаралды 46 М.
MS Excel 101: Text functions in MS Excel
20:31
MS Excel 101: Text functions in MS Excel
Profectus Academy
Рет қаралды 630
How to determine SWP in volatile returns environment?
8:35
How to determine SWP in volatile returns environment?
Profectus Academy
Рет қаралды 124
КАК ПОЗНАКОМИТСЯ С ДЕВУШКОЙ На велосипеде #shorts
0:34
КАК ПОЗНАКОМИТСЯ С ДЕВУШКОЙ На велосипеде #shorts
Леха МАК
Рет қаралды 10 МЛН
Cool Items!🥰 New Gadgets, Smart Appliances, Kitchen Tools Utensils, Home Cleaning, Beauty #shorts
0:15
Cool Items!🥰 New Gadgets, Smart Appliances, Kitchen Tools Utensils, Home Cleaning, Beauty #shorts
Cool Items Official
Рет қаралды 17 МЛН
Dad took her, blood pressure soared 180 directly.😡When she came back from the bath, she saw this s
0:12
Dad took her, blood pressure soared 180 directly.😡When she came back from the bath, she saw this s
开心baby
Рет қаралды 29 МЛН
Mom and son trying Perfect pitch challenge #shorts #challenge #family
0:13
Mom and son trying Perfect pitch challenge #shorts #challenge #family
The Beverly Halls
Рет қаралды 35 МЛН
Dad took her, blood pressure soared 180 directly.😡When she came back from the bath, she saw this s
0:12
Dad took her, blood pressure soared 180 directly.😡When she came back from the bath, she saw this s
开心baby
Рет қаралды 29 МЛН
Затопили квартиру 😮
0:22
Затопили квартиру 😮
WORLD TOP
Рет қаралды 13 МЛН
First Aid for Nosebleeds 🩸🤕 #ambulance #firstaid #paramedic #hospital #emergency #nurse
0:39
First Aid for Nosebleeds 🩸🤕 #ambulance #firstaid #paramedic #hospital #emergency #nurse
BavariaMedic
Рет қаралды 54 МЛН