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:

- In-depth overview of the VLOOKUP syntax:

= VLOOKUP ( lookup_value, table_array, col_index_num, range_lookup ).

- Examples of how to set up intelligent formulas which pull information based on other cells rather than typed in (aka hard-coded) values.

- How to set up an intelligent order query which pulls a full row of information about different orders using one formula that gets copied and pasted.

Download the Advanced VLOOKUP Examples workbook to follow along with the video:
excelexposure.files.wordpress.com/2012/12/advanced-vlookup-examples.xlsx

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…