Having leading or trailing spaces around text is one of the most common reasons why vlookup fails. The solution to this problem is simple: the trim function. Trim removes spaces from around text. Wrapping the lookup_value and the table_array inside the trim function makes vlookup much more sturdy. Trim operates on one value at a […]
Many governments and businesses use fiscal years that are different than the calendar year. A fiscal year that runs from April 1 to March 31 of the following year is quite common. In this post, I’ll demonstrate how to create an Excel function that will tell you which fiscal year any date belongs to. Let’s […]
If you use Excel a lot, probably the best thing you can do to become more efficient is to learn all the keyboard shortcuts. Switching back and forth between the keyboard and mouse really slows things down. In the following example, I’m going to show how you can use the arrow keys in combination with […]
