Defining a Name over 255 characters?

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

Firstly, thanks for the responses, I really appreciate the help,

I tried to enter the piece by piece by piece until it wouldn't allow me into the 'refers to' line in Define Name,
And then copy pasted into word to find that I entered exactly 255 characters before it wouldn't allow me to enter anything else,

But how would vlookup help me? Could I lookup the cells with the charts in them?

I've been using this template that I found on the link I posted in my original post select-chart-to-display (1).xls