• 12 years ago
In this video Guru tells how to use the combination of Index and Match formula to look up a value with approximate match. To download the training file please visit www.myelesson.org

Recommended

7:37
I
Up next
How to use VLookup formula in excel | Part 3
Kathleenkeeble64
7:50
Learn Vlookup Formula For Beginners in Excel -
Knowledge Valley
26:38
Advance Excel Lesson 9 - Excel Formula Basics
Everything
8:23
VLOOKUP WILDCARD
RAKESH KUMAR
7:04
What Is Adsense And How To Apply For It (Hindi)
Excelmadeeasy Guru
3:58
What Is Adsense And How To Apply For It (English)
Excelmadeeasy Guru
7:52
WhatIf Analysis in Excel English
Excelmadeeasy Guru
8:08
Conditional Formatting: Format A Cell Based On A Formula (Hindi)
Excelmadeeasy Guru
5:41
Conditional Formatting: Format A Cell Based On A Formula (English)
Excelmadeeasy Guru
12:20
Index & Match Formula 12 - Reference & Area To lookup Ans From 3 Different Tables Hindi
Excelmadeeasy Guru
9:00
Index & Match Formula 12 - Reference & Area To lookup Ans From 3 Different Tables English
Excelmadeeasy Guru
2:53
Index And Match -11 - With Max Formula Lookup The Highest Value (Hindi)
Excelmadeeasy Guru
2:39
Index And Match -11 - With Max Formula Lookup The Highest Value (English)
Excelmadeeasy Guru
3:53
Index And Match -10 - With Min Formula Lookup The Lowest Value (Hindi)
Excelmadeeasy Guru
3:21
Index And Match -10 - With Min Formula Lookup The Lowest Value (English)
Excelmadeeasy Guru
3:37
Index and Match 9 Sum a Column based on a condition Hindi
Excelmadeeasy Guru
2:34
Index and Match 9 Sum a Column based on a condition English
Excelmadeeasy Guru
2:18
Index And Match 8 Sum A Row based On A Condition Hindi
Excelmadeeasy Guru
3:06
Index And Match 8 Sum A Row based On A Condition English
Excelmadeeasy Guru
4:07
Index And Match 7 - 2 Way Lookup (Hindi)
Excelmadeeasy Guru
3:55
Index And Match 7 - 2 Way Lookup (English)
Excelmadeeasy Guru
4:21
Index And Match 6 - 2 Way Lookup (English)
Excelmadeeasy Guru
3:25
Index And Match 5 - 2 Way Lookup (Hindi)
Excelmadeeasy Guru
3:04
Index And Match 5 - 2 Way Lookup (English)
Excelmadeeasy Guru
2:54
Index And Match 4 - Lookup A Value On The Left(English)
Excelmadeeasy Guru