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

Recommended

3:58
I
Up next
What Is Adsense And How To Apply For It (English)
Excelmadeeasy Guru
5:41
Conditional Formatting: Format A Cell Based On A Formula (English)
Excelmadeeasy Guru
7:04
What Is Adsense And How To Apply For It (Hindi)
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
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
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
2:59
Index And Match Formula 3 (Hindi)
Excelmadeeasy Guru
2:25
Index And Match Formula 3 (English)
Excelmadeeasy Guru
3:41
Index And Match Formula 2 (Hindi)
Excelmadeeasy Guru
2:58
Index And Match Formula 2 (English)
Excelmadeeasy Guru
5:39
WhatIf Analysis in Excel English
Excelmadeeasy Guru