Using Lookup Functions

Book cover This article is an excerpt from Excel 2007 Formulas by John Walkenbach. Also known as, Mr. Spreadsheet, John is arguably the foremost authority on Excel. His forty-plus books include Excel 2007 Power Programming with VBA, Excel 2007 Charts, and the bestselling Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pack. Visit to learn more about this book.

This article discusses various techniques that you can use to look up a value in a table. Excel has three functions (LOOKUP, VLOOKUP, and HLOOKUP) designed for this task, but you may find that these functions don’t quite cut it. This article provides many lookup examples, including alternative techniques that go well beyond Excel’s normal lookup capabilities.

Read Article button

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language