Lesson 4-5 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Use intersection range names and the INDIRECT function

Play The Video

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 | |

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. |