indirect

Excel Basics

INDIRECT Function with Named Ranges

In this tutorial, we are going to cover how to use the INDIRECT Function with named ranges in Excel. Before we begin, please make sure you have a firm understanding on how to use the INDIRECT Function. For this example, we will be using the following formula. =INDIRECT(ref_text, [A1]) Before we can proceed, we first…