SOLVED

Display the amount ( value K€ ) according to several criteria

New Contributor

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 ) following these criteria please : 

- Type : Elec or AC or Masonry or Plumbing and...
- Category : 'Gros oeuvre" in blue

-> All defined by Hub ( Wh ). 

I hope I was clear enough in my wording. 

Thank you in advance for your valuable help. 

Kind regards, and have a nice day 

 

3965247a-adea-4e95-9b10-3290658f935b.pngCapture d’écran 2022-03-28 160432.png

 

 

5 Replies

Does anyone have any insights please?
I've tried a lot of things, but not being very familiar with the tool, I'm stuck...
Thanks in advance

@abrunel83 

See attached file. Maybe this is what you are looking for.

Thanks for your feedback @Quadruple_Pawn.
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
best response confirmed by Hans Vogelaar (MVP)
Solution

@abrunel83 

See attached file. I hope this is what you are looking for.

Excellent, it works!
Thanks a lot @Quadruple_Pawn 
Could you please explain the logic behind it with the formulas?