Excel Lookup Series #3: VLOOKUP Function 3rd Example
See how to Use VLOOKUP to deliver a value to a formula. See how to deliver a late fee percentage to a formula using the VLOOKUP. In a formula, the VLOOKUP function can evaluate to a number that the formula can use to make a calculation. 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.
Length:
03:38