This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

Figure A We’ll create two Excel drop down lists based on this simple data set. We need two Excel drop down lists. The first Excel drop down list will set the condition, the region.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

How to Make a List in Excel for Mac. The Mac version of Excel contains the same features as its Windows counterpart, including the standard filtering tools and preformatted formulas.