Dyamic ranges (?)

[Elijah]

Hi there,

I've been using the offset function within named ranges in my charts and
also a dropdown list (through data validation) so users can select the data
to be displayed. An IF function referenced to this dropdown list basically
drives the selection.

The problem is that the IF function is limited in the number of selections
(i think 7 nested functions max) - and I'm after a way for users to select
more than data ranges for display in a chart.. Can anyone help me with this?

Elijah

 

[Bernard Liengme]

All functions (not just IF) are limited to 7 levels of nesting.
How about using a LOOKUP function in place of IF?

Best wishes