Forum Discussion
Solved
Display the amount ( value K€ ) according to several criteria
Hello to all, I would like to find the formula that based on the quotes I would add in spreadsheet 1 ( 2nd chart ) will automatically enter the value ( amount ) in spreadsheet 2 ( 1st chart ) fo...
See attached file. I hope this is what you are looking for.
See attached file. Maybe this is what you are looking for.
Thanks for your feedback OliverScheurich.
Unfortunately, it doesn't answer my request.
If we take for criterion column Type ( Elec or Plumbing or Air Conditioning or Mansory, etc... and column category "Gros oeuvre" only associated ( table 2 ), display the amount that will be entered directly in table 1.
Ex :
Table 2 :
Hub: mpl-chaptal; Type = Elec; Category = Gros oeuvre ; Amount = 4
Auto result table 1 :
At the intersection of mpl-chaptal and electricty, let the value 4 from above be returned and so on for each Type as soon as the category "Gros oeuvre" is chosen.
I don't know if I am clearer this way
Unfortunately, it doesn't answer my request.
If we take for criterion column Type ( Elec or Plumbing or Air Conditioning or Mansory, etc... and column category "Gros oeuvre" only associated ( table 2 ), display the amount that will be entered directly in table 1.
Ex :
Table 2 :
Hub: mpl-chaptal; Type = Elec; Category = Gros oeuvre ; Amount = 4
Auto result table 1 :
At the intersection of mpl-chaptal and electricty, let the value 4 from above be returned and so on for each Type as soon as the category "Gros oeuvre" is chosen.
I don't know if I am clearer this way
See attached file. I hope this is what you are looking for.
Excellent, it works!
Thanks a lot OliverScheurich
Could you please explain the logic behind it with the formulas?