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
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
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!
Here are a few of the Excel articles that I read last week, that you might find useful:
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.
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.
Save time with our "Done For You" Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.