Quick tip - How to use VLOOKUP. How to use VLOOKUP VLOOKUP is one of the most useful functions in Excel. In a nutshell, it lets you to look up and retrieve information from a table. You can use VLOOKUP to look up product details, a customer name, an employee phone number, a commission rate, and all kinds of other data. You can even use VLOOKUP to combine information in different tables. Basically, when you want data in a table, VLOOKUP can get it for you. Watch this video to learn how to use VLOOKUP in 3 minutes: This video is part of Core Formula, a step-by-step program to teach you Excel formulas. More formula resources If you want to know more about Excel formulas and functions, we have some resources for you: The Minimalist's guide to useful Excel functions – quickly find the Excel function you need. Excel formula recipes – see how Excel functions are used in real life. How to save time with Excel formulas – more than 25 formula tips.
Dave.
SAMR Model. Autism. BETT 2013. Pedagogy and Quoted. ICT in education. QR Codes in the Classroom. Games Based Learning. Learning at Not-School. Podcasting. Infographics. eBooks. Apple. CPD. Ten Things Not Do At Your Training Day - Independent Thinking from Independent Thinking. Mobile Technologies. Resources. Project Based Learning. Flipped Learning. Teaching & Learning.