Excel Function Friday: INDEX for Dynamic Range

Last Friday, there was an HLOOKUP example, and it used a dynamic lookup range -- as rates were added to the lookup table, it automatically expanded to include them.

Today, we'll take a closer look at that dynamic range, and see how the INDEX function is used to set the last cell in the range.

Count the Cells

To find the last column for the INDEX function, you can use the COUNT function to count the rates that are entered in row 2.

=COUNT($2:$2)

Create a Cell Reference

The INDEX function can return a cell reference, based on a

Continue reading Excel Function Friday: INDEX for Dynamic Range