Lookup Logic Update

This past Wednesday I announced the release of Lookup Logic: Harnessing Excel's 17 Most Powerful Functions, and the response has been very gratifying.

Dozens of professionals have already grabbed their copies, and the feedback is outstanding:

I had no idea XLOOKUP could do so much. I spent an hour yesterday converting my old VLOOKUP formulas and my workbooks are cleaner, faster, and easier to maintain. This book paid for itself in the first chapter.
— Michael T., Financial Analyst

The FILTER function section is a revelation. I've been manually filtering and copying data for years. Now I have dynamic reports that update automatically. Game-changer!
— Sarah K., Operations Manager

I was intimidated by Dynamic Arrays, but the book explains them so clearly that I was building sophisticated formulas within an hour. The combination of UNIQUE and SORT for dropdown lists alone was worth the price.
— David R., Data Analyst

Finally, a resource that focuses on modern Excel instead of rehashing the same old VLOOKUP tutorials. This is what I've been looking for.
— Jennifer L., Business Intelligence Specialist

There are only a few days left to save 30%

The introductory discount ends Tuesday, November 11, at 11:59 PM Pacific Time. After that, prices return to normal.

Order Now!

—Allen
     

ExcelTips (ribbon) for 8 November 2025

Formulas
Generating a List of Customers and Transaction Dates

When working with large amounts of data, it can be tricky to figure out how to extract just the information you need. Fortunately, Excel has multiple tools that allow you to examine just the desired data.

Read this tip »

(Thanks to Brian Dorey, Ryszard Raciborski, Alan Cannon, Steve Aprahamian, Michael Avidan (MVP), Kevin Keyser, Andrija Vrcan, Stephen Farrell, Jacques Raubenheimer, Dick Downey, Tzvi Liberman, and Patrick Sedgwick for contributing to this tip.)

 
Data Validation
Single-Use Drop-Down List

Want to create an easy drop-down list? You can do so by using the data validation features of Excel.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Files
Opening a Workbook with Two Windows

If you open a workbook and notice that Excel displays two windows for it, this has to do with how the workbook was saved. Here's how to get back to a single workbook.

Read this tip »

 
Editing
Splitting Information into Rows

Got too much information in a single cell? Here's how you can use a macro to pull apart that information and put it into cells in the way you want.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Displaying a Worksheet from a Drop-Down List Choice

I know I can use data validation to create a drop-down list. What I don't know is how to use the drop-down list in conjunction with the HYPERLINK function so the user can jump to a particular worksheet. In other words, they pick something in the drop-down list, then click on a link that says "Go to Report," and then the report they selected in the drop-down list is displayed. Is there a way to represent the report's worksheet (the target) in the drop-down list, as well as the name displayed in the drop-down list?
—Mark Garrison (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939