KEMBAR78
Extract Data From Sheet | PDF | Applied Mathematics
Scribd
Upload
30 views13 pages

Extract Data From Sheet

The document contains a sample dataset of employee information including ID, names, state, and salary. It demonstrates various Excel functions such as VLOOKUP, INDEX, and Advanced Filter for extracting and consolidating data. Additionally, it shows how to use the Name Box for data extraction and provides examples of sales data for different products.

Uploaded by

Alan Winterton
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
30 views13 pages

Extract Data From Sheet

The document contains a sample dataset of employee information including ID, names, state, and salary. It demonstrates various Excel functions such as VLOOKUP, INDEX, and Advanced Filter for extracting and consolidating data. Additionally, it shows how to use the Name Box for data extraction and provides examples of sales data for different products.

Uploaded by

Alan Winterton
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Sample Dataset

ID First Name Last Name State Salary


101 April Beren NY $2,200
102 Christian Bale CA $2,100
103 Natasha Austin MI $2,500
104 Shane Lee WI $1,800
105 Alfred Moyes OH $1,700
106 Gregory Simson FL $1,900
107 Jerry Seinfeld GA $2,000
108 Richard Hockley NY $2,600
Extract Data Using VLOOKUP function

ID First Name Last Name State Salary


101 April Beren NY $2,200
102 Christian Bale CA $2,100
103 Natasha Austin MI $2,500
104 Shane Lee WI $1,800
105 Alfred Moyes OH $1,700
106 Gregory Simson FL $1,900
107 Jerry Seinfeld GA $2,000
108 Richard Hockley NY $2,600
VLOOKUP Function

ID Salary
103 2500
106 1900
108 2600
INDEX + MATCH

ID Salary
103 2500
106 1900
108 2600
Extract Data Using Advanced Filter

ID First Name Last Name State Salary


101 April Beren NY $2,200
102 Christian Bale CA $2,100
103 Natasha Austin MI $2,500
104 Shane Lee WI $1,800
105 Alfred Moyes OH $1,700
106 Gregory Simson FL $1,900
107 Jerry Seinfeld GA $2,000
108 Richard Hockley NY $2,600

Salary
>2000
Using Advanced Filter

ID First Name
101 April
102 Christian
103 Natasha
108 Richard
Sample Data For Consolidation Method

Product Sales 1 Product Sales 2


Apples 1500 Grapefruit 2000
Grapes 1800 Grapes 1750
Bananas 1200 Apples 1650
Lemon 900 Lemon 900
Pine apple 1300 Melons 1000
Melons 1000
Sales 1 Sales 2
Apples 1500 1650
Grapefruit 2000
Grapes 1800 1750
Bananas 1200
Lemon 900 900
Pine apple 1300
Melons 1000 1000
Extract Data Using Name Box

ID First Name Last Name State Salary


101 April Beren NY $2,200
102 Christian Bale CA $2,100
103 Natasha Austin MI $2,500
104 Shane Lee WI $1,800
105 Alfred Moyes OH $1,700
106 Gregory Simson FL $1,900
107 Jerry Seinfeld GA $2,000
108 Richard Hockley NY $2,600
Using Name Box

ID First Name Last Name State Salary


101 April Beren NY 2200
102 Christian Bale CA 2100
103 Natasha Austin MI 2500
104 Shane Lee WI 1800
105 Alfred Moyes OH 1700
106 Gregory Simson FL 1900
107 Jerry Seinfeld GA 2000
108 Richard Hockley NY 2600
Extract Data Using INDEX function

ID First Name Last Name State Salary


101 April Beren NY $2,200
102 Christian Bale CA $2,100
103 Natasha Austin MI $2,500
104 Shane Lee WI $1,800
105 Alfred Moyes OH $1,700
106 Gregory Simson FL $1,900
107 Jerry Seinfeld GA $2,000
108 Richard Hockley NY $2,600
Using INDEX function

Row Column Output


6 3 Moyes

You might also like