Match Formula - Approximate and Excat Match 2nd Variation

"In this video Guru tells how to use the Match formula with the approximate and the exact options. This is the 2nd variation that I is being explained in this video. The Excel Match function looks up a value in an array, and returns the position of the value within the array. The user can specify that the function should only return a result if an exact match is found, or that the function should return the position of the closest match (above or below), if an exact match is not found.

Related Videos