How To Use Excel Vlookup Video
So i created this video to show you the step by step process to create them and.
How to use excel vlookup video. In the last of this video you learn how to use vlookup and hlookup in microsoft excel. In its most common usage vlookup is a database function meaning that it works with database tables or more simply lists of things in an excel worksheet. How to use vlookup in microsoft excel 2010 from power excel 2010 with mr. Vlookup works a lot like a phone book where you start with the piece of data you know like someone s name in order to find out what you don t know like their phone number. How to use vlookup in excel here we have the book ids and authors and we need to look up the book title in another sheet.
There is one prerequisite that will make your work a lot easier. Select the lookup values starting with your key column and enter a name for the range into this box. Vlookup is an excel function. And its uses in very easy method https youtu be cha3dqu3ito. This article will assume that the reader already has a passing understanding of excel functions and can use basic functions such as sum average and today.
Learn more at the excel help center. This tutorial demonstrates how to use excel vlookup with an easy to follow example and takes you st. Learn how to use the vlookup function in microsoft excel.