Select Page

Excel Video 65 Concatenate to VLOOKUP

Excel Video 65 covers a common problem in VLOOKUP, what to do when there’s a problem with the data you’re looking up. In the video example, the accounting data has an account number and a department number. There are several departments using each account number, so...

Excel Video 64 Matching Data Types for 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...

Excel Video 63 Exact vs Approximate Match and IFERROR

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...

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...