ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Example of VLookUp function (https://www.excelbanter.com/excel-worksheet-functions/131066-example-vlookup-function.html)

Louise

Example of VLookUp function
 
Hi all

I am looking for an example of a VLookUp table which I can show to my
students. They know how to use them and their capabilities, however, I want
to give them an 'exercise' to do and am wondering if anybody has a workbook
with data I could create a lookup from, rather than creating something from
scratch.

Thanks for any help.
Louise

Mike

Example of VLookUp function
 
Lots of data about a packaging plant

http://www.savefile.com/files/496386



"Louise" wrote:

Hi all

I am looking for an example of a VLookUp table which I can show to my
students. They know how to use them and their capabilities, however, I want
to give them an 'exercise' to do and am wondering if anybody has a workbook
with data I could create a lookup from, rather than creating something from
scratch.

Thanks for any help.
Louise


Bob Phillips

Example of VLookUp function
 
If you mail me, I will mail you back a simple grading table using VLOOKUP.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Louise" wrote in message
...
Hi all

I am looking for an example of a VLookUp table which I can show to my
students. They know how to use them and their capabilities, however, I
want
to give them an 'exercise' to do and am wondering if anybody has a
workbook
with data I could create a lookup from, rather than creating something
from
scratch.

Thanks for any help.
Louise




Louise

Example of VLookUp function
 
Thanks for the workbook, I'm sure I can do something with it.
Louise

"Mike" wrote:

Lots of data about a packaging plant

http://www.savefile.com/files/496386



"Louise" wrote:

Hi all

I am looking for an example of a VLookUp table which I can show to my
students. They know how to use them and their capabilities, however, I want
to give them an 'exercise' to do and am wondering if anybody has a workbook
with data I could create a lookup from, rather than creating something from
scratch.

Thanks for any help.
Louise


JLatham

Example of VLookUp function
 
In addition to those offered above, I'll add my own offering. On this page
there are several 'introductory' topics on Excel, there is a .pdf document I
put together that may add to your classroom discussion in the future, and it
has a workbook to go with the .pdf document. Look for the "Lookups in Excel"
and "Lookups Lesson Workbook" links on this page:
http://www.jlathamsite.com/LearningPage.htm



"Louise" wrote:

Hi all

I am looking for an example of a VLookUp table which I can show to my
students. They know how to use them and their capabilities, however, I want
to give them an 'exercise' to do and am wondering if anybody has a workbook
with data I could create a lookup from, rather than creating something from
scratch.

Thanks for any help.
Louise



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com