Category Archive: Excel Advanced Formula

Jan 22

INDEX – MATCH Formula’s Combination

INDEX – MATCH Formula’s Combination VLookup – Searching a value in the left-most column of table array and return value based on column index number.   Combined INDEX MATCH –   formulas work as a right to left lookup, whereas VLOOKUP only works left to right. We can use INDEX MATCH to lookup a value that is …

Continue reading »

Feb 05

Finding Upper Bound and Lower Bound Range from DataSet

Excel Advanced Formula Tricks #2:  How to find the Upper Bound Range and Lower Bound Range from the given data set? Solution:            We can achieve this by using Match Function in Excel. There is no direct way to do this in Excel.  Please watch the video below to achieve this …

Continue reading »

Dec 13

Excel Advanced Formula Tricks: Min ignore Zero for non-contiguous range

Sub: Min ignore Zero for non-contiguous range   Issue:         How to ignore zero in the min formula for a non-contiguous range ? Solution:   If the above solution is useful please leave your comment below.