How to Subtract value, based on two different conditions
Hi,
I have MS Excel 2007 and I have to prepare my team availability matrix for superiors. But I am not a user friendly about formulas and macros. So need your help.
Formula’s or macro required for solving my query.
I have two tables:
Table A - Present Available manpower count
Jun-15 Jul-15 Aug-15 Sep-15
Skill1 1 2 5 1
Skill2 3 3 1 1
Skill3 2 2 2 1
Table B - New Program Requirement
Skill1 Skill2 Skill3
Prog1 2 1 1
Prog2 2 3 3
Problem / Query : I want that, if I am selecting from drop drown list a program name (example Prog1), and selecting month (example Jul-15) from another dropdown list . On the basis of both selection, it subtract the value in Table A from Jul-15 to till Sep-15 in Skill1 , Skill2, Skill3 as per value available in Table B Skill1, Skill2, Skill3 of Prog1.
Selection of program and month is dynamic , may be Prog2 and Month Jun-15 selected , then it will subtract value from month Jun-15.
Result will like this -
Program Prog1 Selection Month Jul-15
Table A - Present Available manpower count (Subtract value)
Jun-15 Jul-15 Aug-15 Sep-15
Skill1 1 0 3 -1
Skill2 3 2 0 0
Skill3 2 1 1 0
Please help me to resolve this.
Thanks
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago