How To Use Excel Vlookup Video

There is one prerequisite that will make your work a lot easier.

How to use excel vlookup video. Learn more at the excel help center. In the last of this video you learn how to use vlookup and hlookup in microsoft excel. 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. In excel use vlookup when you need to find things in a table or range by row. Select the lookup values starting with your key column and enter a name for the range into this box.

And its uses in very easy method https youtu be cha3dqu3ito. This tutorial demonstrates how to use excel vlookup with an easy to follow example and takes you st. When you need to find information in a large spreadsheet or you are always looking for the same kind of information use the vlookup function. Vlookup is an excel function. 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.

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. So i created this video to show you the step by step process to create them and. Learn how to use the vlookup function in microsoft excel.