Excel VLOOKUP and #N/A

#N/A errors in MS Excel using a VLOOKUP formula can be frustrating. It is actually Excel's way of telling you that the value you are searching for isn't in your table of values. To make it look more appealing use the VLOOKUP together with IFERROR function to return a result such as "Not found" or a blank value.

Excel Tips and Tricks

Here are some cool Excel tips that will work in 2003, 2007 or the 2010 version of MS Excel;

Enter Today's Date
Click in the Excel formula bar of an empty cell and type Ctrl+; (semicolon) and it will insert the current date.

Debugging Excel Formulas
In the Excel formula bar highlight part of a formula and press the F9 key. Instead of seeing the calculation you will see the value. It will only evaluate the highlighted portion of the formula. To revert it back to the calculation press ESC.

Auto Filling Week Days
Start with a date typed into a cell. When going to auto fill for sequential dates do a right click mouse drag and when you release the mouse it will pop up a menu to change the date fill to WeekDays.