Advanced VLOOKUP Examples from video aka full 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: The VLOOKUP function is one of the most frequently used functions in all of Excel.In this video lesson I go over some advanced usages of the VLOOKUP function including:nn- In-depth overview of the VLOOKUP syntax:nn= VLOOKUP ( lookup_value, table_array, col_index_num, range_lookup ).nn- Examples of how to set up intelligent formulas which pull information based on other cells rather than typed in (aka hard-coded) values.nn- How to set up an intelligent order query which pulls a full row of info
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!)