How To Use Excel Vlookup Video

And its uses in very easy method https youtu be cha3dqu3ito.

How to use excel vlookup video. 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. There is one prerequisite that will make your work a lot easier. 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. In excel use vlookup when you need to find things in a table or range by row. 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.

Learn how to use the vlookup function 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. In the last of this video you learn how to use vlookup and hlookup in microsoft excel. So i created this video to show you the step by step process to create them and. I receive numerous questions about how to use the vlookup function in excel.

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. This tutorial demonstrates how to use excel vlookup with an easy to follow example and takes you st. Select the lookup values starting with your key column and enter a name for the range into this box.