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!

Tables in Excel Upload Images   Link   Brenda Cannon  12 months ago I can't find the lesson where you go over tables. Thanks! Alex Hedley 12 months ago Beginner 4 does DataTables / Lists Is that what you're after? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

lookup vector Upload Images   Link   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)? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

IF and VLOOKUP Upload Images   Link   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!!! Read More... Reply from Richard Rost: Sounds like you need to use a combination of IF and VLOOKUP. Without seeing your sheet, I can't give you any more direction. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format