Excel Video 179 MATCH from how to use hlookup Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other functions.The syntax of MATCH is:nn=MATCH(what to look for, where to find it, match type).nnWhat to look for (lookup value) and the range to find it are very similar to VLOOKUP and HLOOKUP.The match type is a little different.Instead of true and false, match type can be 1 (largest value that is less than or equal to the lookup value with the data sorted in ascending order, similar to TRUE
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)