|
|
|
|
|
|
MATCH and INDEX Functions
Learn how to look up values
with multiple criteriaThis tutorial will teach you how to use the MATCH
and INDEX functions to look up a value based on multiple criteria. For
example, here I have a list of computer courses that I teach. I offer quantity
discounts based on the number of students a client enrolls. I want to tell Excel
the course code and the number of students and have it figure out what to charge
the client.
Click on the video link below for a full demonstration of
how this is accomplished. This topic is covered in more detail in my
Microsoft
Excel Expert Level 4 class.
Click here to view the FREE video
When you're finished with this tutorial, here's another
FREE video tutorial on
MATCH & INDEX.
By Richard Rost
Click here to sign up for more FREE tips
|
|
Check out these other pages that may be of interest to you: |
|
