vlookup in microsoft excel

Views:
 
Category: Education
     
 

Presentation Description

Vlookup is a function in Microsoft Excel to find data in large worksheets. Once the data has been extracted you can perform further analysis and calculations.

Comments

Presentation Transcript

Slide 1: 

How to perform a Vlookup in Excel http://www.familycomputerclub.com

Slide 2: 

What do you want to know from your data? I want to know what is Tom’s total pay-package http://www.familycomputerclub.com

Slide 3: 

=VLOOKUP(“Tom”,A2:F7,6,False) Vlookup is the function Tom is the value whose total pay-package has to be retrieved A2:F7 is the data range or table array which contains all the data from which we need to extract some information 6 is the column index number where the ‘Name’ column is defined as 1 False indicates a value that tells Vlookup that the data is not sorted. http://www.familycomputerclub.com

Slide 4: 

The correct information has been extracted from the data http://www.familycomputerclub.com

Slide 5: 

http://www.familycomputerclub.com For free Excel training videos Log on to familycomputerclub.com