"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.
