[go: up one dir, main page]
Scribd
Upload
180 views3 pages

Simple VLOOKUP Examples: Learn More About VLOOKUP & Other Lookup Functions. Get My Book

This document provides a simple example of using the VLOOKUP function in Excel. It includes a table with sales data for 12 people including their number of customers, net sales, and profit/loss. Below the table are examples of VLOOKUP formulas to lookup values like John's sales, Jamie's number of customers, and Jessy's profit directly from the table. The document also advertises a book about learning VLOOKUP and other lookup functions in more depth.

Uploaded by

Dimitrios Karadomnas
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
180 views3 pages

Simple VLOOKUP Examples: Learn More About VLOOKUP & Other Lookup Functions. Get My Book

This document provides a simple example of using the VLOOKUP function in Excel. It includes a table with sales data for 12 people including their number of customers, net sales, and profit/loss. Below the table are examples of VLOOKUP formulas to lookup values like John's sales, Jamie's number of customers, and Jessy's profit directly from the table. The document also advertises a book about learning VLOOKUP and other lookup functions in more depth.

Uploaded by

Dimitrios Karadomnas
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/ 3

Simple VLOOKUP Examples

Data
Sales Person No. Customers Net Sales Profit / Loss
Joseph 8 1,592 563
John 8 1,088 397
Josh 8 1,680 753
Jamie 9 2,133 923
Jackie 10 1,610 579
Johnson 10 1,540 570
Jonathan 7 1,316 428
Jagjit 7 1,799 709
Jairam 8 1,624 621
Jessy 6 726 236
Javed 9 2,277 966
Jimmy 6 714 221
Juno 9 2,682 1,023

Learn more about VLOOKUP & other lookup functions. Get my book.

Comprehensive and easy to understand


This is a book for everyone who uses Vlookup. Most of us think… Oh.
open your eyes to some brilliant techniques which can be used acros
Solid introduction to lookup functions
This books does a wonderful job of taking each of the lookup functio
simple, easy-to-understand level, and then showing many examples
$ 9.99 only

Get your copy4


Visit Chandoo.org for more…,

Questions Answer
1. How many sales did John make? 1088
2. How many customers did Jamie have? 9
3. What is the profit of Jessy? 236
4. How many customers did Joshua have? #N/A

Homework
Questions Your Answer
1. How many sales for the person in cell G17?
2. Who made more sales - Jamie or Jackie?
3. What is the sale per customer for Jagjit?
4. What is the profit % for person in G17?

Jonathan

ther lookup functions. Get my book.

rehensive and easy to understand


a book for everyone who uses Vlookup. Most of us think… Oh.. I already know the function. But this book will
our eyes to some brilliant techniques which can be used across Excel. - by Dr. Nitin Paranjape
ntroduction to lookup functions
ooks does a wonderful job of taking each of the lookup functions available in Excel, breaking them down to a
, easy-to-understand level, and then showing many examples of how these functions work. - by Lucas Moraga
Formula
=VLOOKUP("John",$B$5:$E$17,3,FALSE)
=VLOOKUP("Jamie",$B$5:$E$17,2,FALSE)
=VLOOKUP("Jessy",$B$5:$E$17,4,FALSE)
=VLOOKUP("Joshua",$B$5:$E$17,2,FALSE)

. I already know the function. But this book will


ss Excel. - by Dr. Nitin Paranjape

ons available in Excel, breaking them down to a


of how these functions work. - by Lucas Moraga

You might also like