KMeuwissen
New Member
- Joined
- Apr 26, 2016
- Messages
- 2
Hello all.
I'm creating a machine capacity file in Excel, counting the total hours available and deduct some loss of hours.
However I'm having trouble finding a correct formula to make a lookup in a 2d table, getting back 1 value which combines the values of multiple fields.
Simplified, my data looks as follows :
machine
week date A B C D
17 01/04/16 8 8
17 03/04/16 8
17 04/04/16 8
18 08/04/16 8
18 09/04/16 8
I have inserted a slicer to choose the machine, choices of the slicer are being put into 1 row (eg 1st value in A1, 2nd in A2, etc...)
This means multiple machines can be selected.
Depending on this selection I would need to retrieve the corresponding data from the table
Example -> for wk 17, when selecting machine A, B & D the returned value should be 24
Any suggestions ?
Thanks in advance
I'm creating a machine capacity file in Excel, counting the total hours available and deduct some loss of hours.
However I'm having trouble finding a correct formula to make a lookup in a 2d table, getting back 1 value which combines the values of multiple fields.
Simplified, my data looks as follows :
machine
week date A B C D
17 01/04/16 8 8
17 03/04/16 8
17 04/04/16 8
18 08/04/16 8
18 09/04/16 8
I have inserted a slicer to choose the machine, choices of the slicer are being put into 1 row (eg 1st value in A1, 2nd in A2, etc...)
This means multiple machines can be selected.
Depending on this selection I would need to retrieve the corresponding data from the table
Example -> for wk 17, when selecting machine A, B & D the returned value should be 24
Any suggestions ?
Thanks in advance
)
