Tag Archives: IFERROR

Select Drop Down Item and use VLOOKUP to Return Multiple Attributes

In this post, we’ll explore a method to allow a user to select an item from a drop-down list and then use formulas with the VLOOKUP function to retrieve multiple values from the related item table. Objective Before digging into the mechanics, let’s review our objective with an example. We would like to allow our […]

Clean up Reports with IFERROR

In the old days, we could use a combination of the IF and ISERROR functions to clean up reports. This method was good, and worked for many years…but starting with Excel 2007 there is an easier alternative. This post explores the IFERROR function. Overview The IFERROR function enables us to use a single function to […]

Find the Last Occurrence of a Delimiter to Retrieve the Lowest Sub Account from Quickbooks in Excel

In this post, we’ll explore a formula-based approach that does not use VBA to find the last occurrence of a delimiter and use it to retrieve the lowest sub account from a Quickbooks account list in Excel. When I was doing some research for a project I had a couple of years ago, I was […]