Select Page

Excel Video 62 Multiple VLOOKUP Columns

Excel Video 62 uses the same example as Excel Video 61, adding the wrinkle that you can look up multiple columns in the same table. Notice that my diagnosis code reference table has three columns, the diagnosis code, the diagnosis description, and the diagnosis...

Excel Video 61 Introducing VLOOKUP

Excel Video 61 is the first video in a new series covering VLOOKUP. If you’ve never seen VLOOKUP before, you’ll find it to be a real time-saver when it comes to managing multiple sets of data. If you’re familiar with VLOOKUP, stay tuned. Once we’re through the...

Excel Video 60 Stop if True

Excel Video 60 wraps up our discussion of Conditional Formatting with a discussion of the Stop If True box in the Conditional Formatting Rules Manager. The Stop If True box was included in Excel 2007 to support compatibility with prior versions of Excel. Older...

Excel Video 59 Manage Conflicting Rules

Excel Video 59 continues our review of what Excel does when multiple Conditional Formatting rules are applied to the same cell or range of cells. Excel has a Conditional Formatting Rules Manager window that shows all of the conditional formats applied to a given cell...

Excel Video 58 Manage Rules

Excel Video 58 introduces the idea of multiple conditional formatting rules applied to the same range of cells. For example, the video highlights a range of cells using color scales and then wants to bold the highest cell value in the range. Excel Video 58 introduces...