jaanuparthu1718
New Member
- Joined
- Mar 14, 2016
- Messages
- 5
Hi Folks,
I am preparing a Projections and Invoiced sheet for Invoicing. I have 2 sheets 1) Project Actuals ($) & 2) Project Projections ($).
1) What I would like to know is that - If my cell text is named as Projected under Project Actuals ($) (F3) it should be able to fetch values from Project Projections sheet (I4) against that particular month.
2) Secondly if my cell text name is changed to Invoiced (F3) under Project Actuals ($) then it should fetch the values from Project Projections ($) sheet from the Invoiced column (J4).
I know my ask might be peaks but I am not so good at excel but hoping there might be a solution for every question asked. Thanks in advance.
I am preparing a Projections and Invoiced sheet for Invoicing. I have 2 sheets 1) Project Actuals ($) & 2) Project Projections ($).
1) What I would like to know is that - If my cell text is named as Projected under Project Actuals ($) (F3) it should be able to fetch values from Project Projections sheet (I4) against that particular month.
2) Secondly if my cell text name is changed to Invoiced (F3) under Project Actuals ($) then it should fetch the values from Project Projections ($) sheet from the Invoiced column (J4).
I know my ask might be peaks but I am not so good at excel but hoping there might be a solution for every question asked. Thanks in advance.