A bit hard to make a proper name, but I have the following sitiuation:
I have a tab with loads of data.
I have a second tab, where I select data with match and compare. works perfect
based on this second tab I have Graph made.

Now the problem, I have several sets of data for different customers, and want to have a different table made, when I change the input table.

e.g.
=ALS(E$4=0;0;MATCH(data2_tot;COMPARE($A5;data2_dates);COMPARE(E$4;data2_USDtot_names;0)))
for all cells data2_tot is used to form tab2 and the graph

instead of data2_tot, I want to use data1_tot to show a graph for cust 1, or data3_tot for cust 3.

I thought to put the the defined name in a cell, say A1, and then make the formula: =ALS(E$4=0;0;MATCH(A1;COMPARE($A5;data2_dates);COMPARE(E$4;data2_USDtot_names;0)))
but that doesn't work, as only A1 is used and not the whole area where the defined name in A1 is refering to.

How can I make that work?

Oh, it is not the idea to have a table and graph for every customer, but one which I can use for all, based on the data I refer to.