by Nate Moore | Jul 27, 2011 | Functions
Excel Video 178 introduces INDEX, a more flexible lookup function than VLOOKUP or HLOOKUP. One of the shortcomings of VLOOKUP, for example, is that the data you’re looking for has to be in the far left column of the range you’re looking in. (No, you can’t enter a...
by Nate Moore | Jul 25, 2011 | Functions
Excel Video 177 demonstrates an easy way to add a drop-down selection box to your worksheet. All of the formulas on this tab are based on having one of the five mutual funds in cell B8. To help my users put the right value in B8, I use Data Validation from the Data...
by Nate Moore | Jul 20, 2011 | Functions
In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula, the column reference doesn’t change. We used an Excel function called COLUMN as the column reference so that we could easily copy the VLOOKUP formulas. In Excel...
by Nate Moore | Jul 18, 2011 | Functions
Excel Video 175 tackles HLOOKUP. HLOOKUP is very similar to VLOOKUP, so similar in fact that we’ll use the same data from the VLOOKUP videos to discuss HLOOKUP. The difference between VLOOKUP and HLOOKUP literally is the first letter. V stands for Vertical (look in...
by Nate Moore | Jul 13, 2011 | Functions
VLOOKUP’s a great function, but when you try to copy a VLOOKUP formula, watch out for a gotcha you’ll see in Excel Video 174. When you copy most formulas in Excel, Excel updates the references as you copy. That’s not true with VLOOKUP. When you copy a VLOOKUP formula,...
