Multiple VLookup: An Advance Technique of Microsoft Excel

Multiple vlookup is a technique used to return multiple values from a single vlookup formula in Excel. This can be achieved by nesting multiple vlookup formulas together, or by using the INDEX and MATCH functions in combination.

Here are the steps to perform a multiple vlookup using nested vlookup formulas:

1. Open the Excel spreadsheet containing the data you want to use in the multiple vlookup formula.
2. Select the cell where you want the first vlookup formula to be entered.
3. Type "=VLOOKUP(" and then select the cell containing the value you want to look up.
4. Type a comma and then select the range of cells containing the data you want to search through. Be sure to include the column containing the data you want to return in this range.
5. Type another comma and then enter the number of the column containing the data you want to return.
6. Type another comma and then enter either "TRUE" or "FALSE".
7. Press "Enter" to complete the first vlookup formula.
8. Select the cell containing the formula and type "=VLOOKUP(" again.
9. Select the value returned by the first vlookup formula and use it as the lookup value in the second vlookup formula.
10. Repeat steps 4-9 for additional vlookup formulas as needed.

Alternatively, multiple vlookup can be performed using INDEX and MATCH functions. The INDEX function is used to return a value from a specific cell in a range of cells, while the MATCH function is used to find the position of a value within a range of cells.

(Click Here to know more about VLookup and HLookup)

Here are the steps to perform a multiple vlookup using INDEX and MATCH:

1. Open the Excel spreadsheet containing the data you want to use in the multiple vlookup formula.
2. Select the cell where you want the multiple vlookup formula to be entered.
3. Type "=INDEX(" and then select the range of cells containing the data you want to search through.
4. Type a comma and then enter "MATCH(" and select the cell containing the value you want to look up.
5. Type a comma and then select the range of cells containing the values you want to match against.
6. Type another comma and then enter "0" to indicate an exact match is desired.
7. Close the parentheses and press "Enter" to complete the formula.
8. Repeat the formula for multiple matches in different columns or rows.

Note: The above steps are for the basic multiple vlookup, you could use more advanced methods like using arrays or using helper columns to get more complex multiple vlookup.