Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

How To Use Index/Match, The One Microsoft Excel Trick That Separates The Gurus From The Interns

Walter HickeyJul 12, 2013, 01:19 IST

Flickr / Microsoft SwedenBill Gates using an early version of Microsoft ExcelWe've been writing a lot about Microsoft Excel formulas.

The program is the gold standard of programs. It's elegant, ubiquitous, and outstandingly powerful.

American business lives and dies by the spreadsheet, and everyone is always looking to hone their skills.

There's one trick, though, that separates the quants from the interns.

That trick is Index/Match, a function that can find any value in any spreadsheet.