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.

This is what separates the Excel masters from the wannabes

Sara SilversteinFeb 10, 2015, 17:32 IST

Your browser doesn't support HTML5 video.

kalturavideoplaceholder

Subscribe to BI: Excel on YouTube

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

Produced by Sara Silverstein