Hi there,

I'm trying to make a chart viewer on the first sheet of my spreadsheet and am using this website as a guideline, http://chandoo.org/wp/2008/11/05/sel...art-from-many/
However instead of the 3 charts in the example, I have 12 which makes my formula for defining a name substantially longer.

By moving my charts to the same sheet and getting rid of the INDIRECT formulas, I shortened my formula to 291 characters which is too long as the limit is 255.

=IF($G$9="Sodium",$N$34,IF($G$9="Manganese",$N$35,IF($G$9="Iron",$N$36,IF($G$9="Nitrate Nitrite",$N$37,IF($G$9="Nitrite",$N$38,IF($G$9="Nitrate",$N$39,IF($G$9="PH",$N$40,IF($G$9="Conductivity",$N$41,IF($G$9="Turbidity",$N$42,IF($G$9="Fluoride",$N$43,IF($G$9="Selenium",$N$44,$N$45)))))))))))

Is there any way to make my formula shorter? Or to reference a cell where I place the formula?

Thanks,
Faraz