Hey guys,
I am new to this forum.
Currently I am working on a small project and I am very close to the solution.
The case is as followed:
I have three columns - ABC - DateX, Project and Hours. They get populated via other sheets, the data changes every month. I made also from each column a dynamic ranged.
From column D till column AI i have a calendar.
I use an Index function to get the hours from column C to populate the calendar based on the date and project.
However, the Index function does not work correctly, it shows the wrong values on the calendar and when change a value it changes other values in the calendar.
In another forum someone helped me by providing me the following solution:
As you can see in the attachment, the first of January it provides the wrong value in the calender.
What do I do wrong?
Thanks in advance!
See attachment for more details. View attachment Calendar_Vlookup_v0.3.xlsx
I am new to this forum.
Currently I am working on a small project and I am very close to the solution.
The case is as followed:
I have three columns - ABC - DateX, Project and Hours. They get populated via other sheets, the data changes every month. I made also from each column a dynamic ranged.
From column D till column AI i have a calendar.
I use an Index function to get the hours from column C to populate the calendar based on the date and project.
However, the Index function does not work correctly, it shows the wrong values on the calendar and when change a value it changes other values in the calendar.
In another forum someone helped me by providing me the following solution:
Code:
{=IFERROR(INDEX(hours,SMALL(IF(dateX=E$15,IF(project=$D16,hours)),1)),"")[COLOR=#333333]}[/COLOR]
As you can see in the attachment, the first of January it provides the wrong value in the calender.
What do I do wrong?
Thanks in advance!
See attachment for more details. View attachment Calendar_Vlookup_v0.3.xlsx