This is what separates the Excel masters from the wannabes

Please enable Javascript to watch this video

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.

Follow BI Video: On Twitter 

Read more stories on Business Insider, Malaysian edition of the world’s fastest-growing business and technology news website.