Join Dennis Taylor for an in-depth discussion in this video Using the INDEX function to extract data by row and column, part of Excel Tips Weekly.
- [Instructor] Excel's index function…has a variety of uses.…If you go to the Formulas tab in the ribbon,…then go to Lookup and Reference,…you will see Index, and its description…"returns a value or reference of the cell…at the intersection of a particular…row and column in a given range."…Expressed a little bit differently…it allows us to extract information…from a table based on a row and column indicator.…On this worksheet here called Index,…we've got some various prices here.…Imagine, this might be something…like you'd see at a post office,…or a shipping facility,…based on the size of the item,…and perhaps they've defined it in a certain way.…
We got five different sizes here.…Depending upon where we're shipping the item,…we've got shipping zone entries.…So, if it's shipping zone seven,…size four, the price is $12.57.…So, over in columns P, Q, R, and S,…we've got various items listed here, identified by a number,…and they're of different sizes and shipping zones.…We want to know what the shipping cost is.…So what we're trying to do, in fact,…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.