Where do we combine INDEX and INDIRECT functions?

Hi,

I have come across the following formula. Could any one explain me where are such formulas used?

=INDEX(INDIRECT(AG3),Age-16,Term-IF(S15="IRR",8,3))

Thanks