The INDIRECT Function is a function which can be used to choose a different range or cell locations.

However i would like to know if its possible to use it in such a way like i have a drop down in which i have formula1 and formula2.

***IMP -this is nothing to do with USINg the SUBTOTAL function.
Lets say i have long formula to be used if i choose formula1 which is entered in one cell location c2 and one more long formula in cell c3 in case of formula2 selected in the drop-down..

like i write completely different formulas to be used in diffferent scenarios as Excel has a limitation of the seven " IF's "...

Can anyone show with a small example in an attachment.