Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel 2010 Expert 4
By Richard Rost     10 years ago

The focus of this course is working with lookup functions in Excel. Topics covered include:

- Using VLOOKUP to get a value from a list
- Assiging a letter grade based on final average
- Understand range lookups vs. exact matches
- Lookup an employee's pay rate, calculate pay
- Use INDEX and MATCH for enhanced lookups
- Create cell references: ADDRESS, INDIRECT
- Calculate year-to-date sales
- Compare two lists for missing items
- Find the value in a list closest to a target value
- Lots More!

Brenda Cannon
7 months ago
I can't find the lesson where you go over tables.
Thanks!
 Alex Hedley 7 months ago Beginner 4 does DataTables / ListsIs that what you're after?
Anonymous
7 years ago
Hi Richard, for the LOOKUP function, does the "lookup_vector" have to be 1st column or row (of a table_array) or could it be any column or row (more like an INDEX function)?
al j
8 years ago
What I am trying to do is create a dataase using Excel. A person keys in M for married, <2 years, then that person point will be 8, <5, then that person point will be 4, >5, then that person point will be 1. I just tried to use a lookup table but I have no clue to use less than equal to formula and lookup at the same time. Help!!!
I have a situation where I need to a number rating Upload Images   Link
al johnson
8 years ago
I have a situation where I need to a number rating 8-1, depending on if you are married, divorced or single and your age less than 21, more than 21, and more than 35. How do you state that in a cell using a vlookup, lookup or reference?
Hong Yuan
8 years ago
For Excel 2010 Expert class 7:

what if we have two people have the exact guesses? I tried it but Excel only matched the first winner's position and missed the second winner who guessed the same.
Benjamin Chua
8 years ago
time 1:18 expert level 4 - where can you find a solution if there is a drop down box in one of the colums? by increasing the rows it is not  giving me a drop down box.

Lynn Staszak
8 years ago
I finally understand the MATCH and INDEX functions! I've never found an example to explain them as well as this training does. Thanks, Richard!