Forum Discussion
Return a value from a reference based on multiple kolumns
Is there anyone that could help me identify the formula/s for retrieving a value from a table with multiple kolumns. The two columns which shall get the data are YTD target and Monthy target . T...
The function worked excellent for getting values per month in G3 but unfortunately not in F3, the Sum of months. It seems as if excel does not understand that when I select March I want the sum of values for January+ February + March in the F column. In my case for KPI 1 it would be a total value of 9.
Do you think there might be a solution for this or do I have to calculate the values manually?
Thank you again.
Do you think there might be a solution for this or do I have to calculate the values manually?
Thank you again.
Here is my test workbook. Does it work for you?
- It's finally working!!!
I did some testing here and there and I have the figures I wanted without any manual input. The combination of your two inputs made it work. Thank you so so so much!
What an amazing forum this is. Noone I know could solve this in this rapid speed as you did, along with OliverScheurich.
Thank you again! - Great, I'd like to post my document and see if you can get it working for you. I have literally written everything the same way as you did but still not the total amount in March.
When I open the document before I apply activation I see that you have the 9 in the YTD target, but as soon as I unlock the editing settings number 2 from (probably January) appears instead.
How do I attach a document here? 🙂