by Nate Moore | Jun 7, 2010 | VLOOKUP
Excel Video 64 warns about a common data mismatch problem when using VLOOKUP. When Excel looks up a value using VLOOKUP, the data types have to match for Excel to find a match. If one value is stored as a text and the other value is stored as a number, Excel will...
by Nate Moore | Jun 2, 2010 | VLOOKUP
Excel Video 63 introduces the difference between exact and approximate matches in the VLOOKUP formula. You’re familiar now with the first three fields in VLOOKUP, what to look for, where is the data table, and what column of information do you want to look in. The...
by Nate Moore | May 31, 2010 | VLOOKUP
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...
by Nate Moore | May 26, 2010 | 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...
by Nate Moore | May 24, 2010 | Conditional Formatting
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...