|
Featured Tutorial
Featured Macro
Excel Lookup Series #5: VLOOKUP Function 5th Example
See how to create an array in a VLOOKUP formula, and see how to have the VLOOKUP function look at a table on a different worksheet than the one the VLOOKUP function sits in.
See how to create an array in a VLOOKUP formula so that you do not have to put the array in the worksheet cells. Use curly brackets, commas and semi-colons to create an array right in your VLOOKUP formula. See array syntax. See how to put the table_array in a VLOOKUP formula!
See how to have the VLOOKUP function look at a table on a different worksheet than the VLOOKUP function.
In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.
This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.
See how to create an array in a VLOOKUP formula so that you do not have to put the array in the worksheet cells. Use curly brackets, commas and semi-colons to create an array right in your VLOOKUP formula. See array syntax. See how to put the table_array in a VLOOKUP formula!
See how to have the VLOOKUP function look at a table on a different worksheet than the VLOOKUP function.
In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.
This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel.