Excel Weekly News from Contextures Jan 7, 2014
Hide VLOOKUP Errors + more Excel tips
In this week's Excel news, you'll see how to hide VLOOKUP errors, and other tips. Thank you for reading the Excel news! It's good to be back after the holiday break.
- Debra firstname.lastname@example.org
My Mouse Went a Little Crazy
Do you use your mouse most of the time, when working in Excel, or do you use the keyboard? It's about half and half for me, using the keyboard to input data, and a few shortcuts, like cut and paste. When I'm selecting things though, I depend on the mouse, so it was hard to get things done when my mouse started acting up recently.
I temporarily switched to a wired mouse, but the long cord gets in the way when you're using a laptop. So, I finally bought a new wireless mouse, and it's easy to get things done in Excel again.
Click here to see the details, on my Debra D's blog: The Overly Sensitive Mouse
Update to the Excel UserForm Course
I've added a new bonus file to my Excel UserForm course, and if you've previously purchased the course, you'll receive the update automatically.
The new file shows how to add Search boxes at the top of the form, then click a button to show a list of all the matching records in the database worksheet. The sample uses transaction data, but you could adapt it for other types of records.
Click here to see the course details, and watch the Search Boxes demo video: Excel UserForm Course
NOTE: The course price is going up on January 15th, so if you're thinking about buying the course, don't wait too long!
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Good news – the Daily Dose of Excel blog is up and running again, after some server problems. Dick Kusleika takes a look at error handling via an error class.
- If you like soccer (football), you might enjoy Jough Donakowski’s article on keeping sports statistics in a spreadsheet.
- The always informative and entertaining Science Goddess finds quick ways to improve the appearance of Excel charts. In another post, she tackles line charts.
- If you’re planning your activities for 2014, you can download a free Excel calendar template from Chandoo’s website.
- And finally, for a humorous peek at what other people are saying about Excel, read the weekly collection of Excel tweets, on my Excel Theatre blog.
Video: Hide VLOOKUP Errors
When you create a VLOOKUP formula with an exact match, an #N/A error might be the result if the value is not found. Instead of showing the error, you can use the IF and ISNA functions to hide the error on the worksheet.
NOTE: You can use IFERROR in Excel 2007 and later versions, but it addresses all errors, not just a specific type.
Old and New
I was lucky to escape the Canadian ice and snow last month, and spend time relaxing in the south. The old trees there are beautiful, and many are covered with hanging Spanish moss. The tree in this photo is in a conservation area, where there was an art exhibit, with 20 modern sculptures, like this one. It's an interesting contrast, between old and new, and man and nature.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2015
All rights reserved.