Excel Advance VLOOKUP in detail

How to use VLOOKUP and advance VLOOKUP in Excel ?

Unlock the power of how to excel your knowledge in excel by learning VLOOKUP with is most useful formula in most of the organizations on daily basis.

When you’re working in organization or have your own business it’s difficult to search precise data which you require in seconds and of that many prefer to use excel

The VLOOKUP in excel is useful way to search values from table in column

• search_key: The exact values you want to search for within a table.
• range: The range where you want to look for the values.
• index: The column number in the table from which to return a value.
• is_sorted: TRUE for an approximate match, FALSE for an exact match.
• logical_expression: An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE.
• value_if_true: What to display if the logical_expression is met.
• value_if_false: What to display if the logical_expression is not met.

Similarly Advance Lookup can be use to search values from table from multiple columns.

Advance VLOOKUP Formula is similar to VLOOKUP but in addition to that we need to use column numbers in form of array

In example above, we need to find color and Price from the table on the left so we first select 2 columns where we want to fill values and apply advance VLOOKUP formula and when applying column number, use “{“ and number put columns which we want and close it with “}”. Also, don’t forget instead of enter after formula use ctl + shift + enter.