## Powerful way to search an excel list automatically

*Article updated on October 31, 2006*

Searching an excel list can be really tedious and boring. Why not use a smart and efficient way to find values really fast!With the function index and match you can find the value to a specific correlating value. (See picture). Type in a ordernumber and out comes the correlating merchandise (fruit). This is a powerful way to do fast searches!

Read further how to find duplicates in an excel list

This post explains how to lookup a value and return multiple values. No array formula required.

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

## Share this article