by Nate Moore | Jun 14, 2010 | VLOOKUP
Excel Video 66 shows an example when you’ll want to find an approximate match (TRUE) instead of an exact match (FALSE) with VLOOKUP. The example shows some patient satisfaction scores from a survey. The survey answers range from 1 to 5, but the values go out to one...
by Nate Moore | Jun 9, 2010 | 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...
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...
