- Home
- IFERROR
VLookup with multiple values
So, you can use a VLookUp to retrieve a piece of information. You can use SumIf to total a range based on criteria and you can use CountIf to count how many times criteria appears. What do you do though when you have to create a VLookUp with multiple values? The VLookUp will run through […]
Continue readingIFERROR
The IFERROR formula in Excel returns a value you specify if a formula results in an error, if there is no error it returns the value of the original formula. The IFERROR function is relatively new to Excel (I believe it started in Excel 2007). For a similar workaround to some VLOOKUP formula error results, […]
Continue readingVLOOKUP
The VLOOKUP is one of Excel’s most useful functions. In its most common form, it is a database function which works with lists of things in databases, or Excel worksheets. Your list of things can be pretty much anything, names and phone numbers, part numbers and details, details of your album collections, etc. A VLOOKUP […]
Continue reading