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 One Of The Best Data Searching Tricks In MS Excel

Kamelia AngelovaJan 8, 2014, 19:31 IST

Your browser doesn't support HTML5 video.

kalturavideoplaceholder

Microsoft Excel is one of the most useful programs ever developed in the history of computing.

One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP.

Complimentary Tech Event

Transform talent with learning that works

Capability development is critical for businesses who want to push the envelope of innovation.Discover how business leaders are strategizing around building talent capabilities and empowering employee transformation.Know More

It's easily one of the handiest ways to sort through and understand large reams of data.

Here, we break down an example of how to use VLOOKUP the right way.

Produced by Daniel Goodman and Walter Hickey