Using multiple criteria in Excel LOOKUP formulas
If you want to look up a value in a table using one criteria, it’s simple.
Refine results
Product
Audience
Publish date
-
-
VLOOKUP Tutorial: Updating prices in a master price list
In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills.
-
Yammer + Ultimate Software = More Engaged Workplace
Today, we are thrilled to announce an integration with Ultimate Software, a leading provider of unified human capital management SaaS solutions, at the company’s Ultimate Connections Conference in Las Vegas. -
5 tips on using Bcc in Outlook email
It’s kind of funny that a software application would use abbreviations that refer to pre-software days. -
Tip: Add a watermark to an Excel worksheet
If you’re collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark.
-
Change the default line spacing in Word
When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.
-
Conditional Formatting Rules Simplified
Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria.
-
Circular Reference? Excel’s most popular (!#?%) error message explained
Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula.
-
Tip: How to cut and paste without messing up formatting
Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey.
-
OneNote Mobile for Android is now available worldwide
You asked, we listened. Today marks the exciting debut of OneNote Mobile for Android in over 20 international markets.
-
“Office 15” Begins Technical Preview
This morning, we reached an important development milestone: the beginning of the “Office 15” Technical Preview Program.
-
Customize! 5 table of contents tricks
The Word 2010 gallery makes adding a basic table of contents quick: Click the References tab, click Table of Contents, and then click the gallery table of contents you want.