Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 10, 2012
Learn Excel how to use the Match formula with text . Also explained is how to use Match with a vertical array and a horizontal array and exact match. The training file shown in the video is available for free download at http://www.myelesson.org 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.