VLOOKUP… to the Left!

Have you ever been attempted to use VLOOKUP in a large data set, only to realize the data you’re seeking is to the left of the lookup column? Sure, you could cut/paste the lookup column the left of the table, but that might interfere with other parts of the dataset. …

Excel Quick Tip: Eliminate Spreadsheet Errors with IFERROR

Spreadsheet errors appear as unprofessional and can put the integrity of your whole report into question. However, there are some circumstances where spreadsheet errors are unavoidable. By using the IFERROR statement, you can manage how errors appear on a spreadsheet.