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