Indirect and Row Excel formula

[finance@2012]

Hello-

Please help me understand what this formula means:

=INDIRECT($E$3&ROW()).

Thanks.

 

[jason]

what is in those target cells?

 

[finance@2012]

AN-

I got it now. It means grab the value in column AN.

Thanks.

 

[Luke M]

If anyone else wants to know, it actually takes the row value of current cell w/ formula and concatenates that value onto the text string "E3". Thus, if the formula is in cell A30, formula becomes:

=INDIRECT("$E$330")


The INDIRECT function takes a text string and converts it into a cell reference. Thus, our formula in A30 is going to look at the value in E330.