Excel Video 178 INDEX from hlookup formula in excel 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: Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP.One of the shortcomings of VLOOKUP, for example, is that the data you’re looking for has to be in the far left column of the range you’re looking in.(No, you can’t enter a negative number for column reference to make VLOOKUP look at prior columns.)Combining INDEX with MATCH is a powerful way to look up a variety of information.nnI’ll start Excel Video 178 by showing you a combined INDEX and MA
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!)