It works like any other function or formula in Excel, like SUM or AVERAGE. VLOOKUP helps you look up a corresponding value for a cell from within your existing database. Open the worksheet, and click Save to OneDrive to edit and practice with the data. We've created a demo worksheet that you can practice with. Here, we'll guide you through the process of how to use the VLOOKUP function in Excel Online.

So what does VLOOKUP do? Like the name implies, it allows you to quickly look up any value that lives somewhere else in your spreadsheet. You can also enhance your digital skills by watching our short but highly informative Microsoft Excel videos.VLOOKUP is one of the most powerful features in Excel, but it's also kind of scary at first glance. Course timelines are flexible, with bitesize classes to full day sessions available. Improve digital skills and productivity within Microsoft apps including Word, PowerPoint and Excel online and desktop versions, plus Teams, Outlook and more.Ĭhoose from a range of introductory courses that help you learn the essentials, or level up your Microsoft skills with an advanced course. We can help you enhance the digital skills within your business and enable your employees to master the entire Microsoft 365 and Office 365 suite. It’s essential in the modern working world for employees to have the digital skills and tools in order to work with maximum efficiency, productivity and collaboration capabilities. New technology in your business means new digital skills for your teams to master. A key part of our solution delivery and support is end user training. We design, deliver and support IT services and solutions that add real value to your business. The 848 Group is a UK leading cloud provider and IT partner. Enhance your skills across the full Microsoft 365 platform