- In cell "C3" you can select either Average or Median

- I need to perform '=average(DATA_RANGE)' or '=median(DATA_RANGE)' based on what is selected in "C3"

- This equation: "="&INDIRECT("C3")&"("&"DATA_RANGE"&")" will return the text "=MEDIAN(DATA_RANGE)"

- So I need to remember how to get Excel to look at my returned text as an equation. Any ideas would be appreciated!

- I have this working fine now using a simple if statement "=IF(C3="MEDIAN",MEDIAN(DATA_RANGE),AVERAGE(DATA_RANGE))". But I'd really like to remember how I got something like this to work before so I can use it on more complicated situations

Any thoughts would be appreciated.
Thanks!