Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Use intersection range names and the INDIRECT function:

Lesson 4-5 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Use intersection range names and the INDIRECT function
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 4: Using Names and the Formula Auditing Tools
Lesson: Lesson 4-5 Use intersection range names and the INDIRECT function Excel INDIRECT function and intersection. Thumbnail from Excel 2013 Expert Skills Lesson 4-5 Use intersection range names and the INDIRECT function.
Description:

This video lesson fully explains how to use the intersection operator in Microsoft Excel formulas, and how this can be used with range names to extract values. This lesson's example contains a table of distances between locations. By using the intersection operator, it's possible to easily extract the distance between any two locations from this table. This lesson also explains the INDIRECT function, which must be used in order to refer to a range name if it is stored within a cell.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email