Hi All :)
I'm trying to use XLOOKUP to fill a list with data from another list.
In list 1 I have the staff assigned to the different projects over the week.
In some cases two staff members will work on the same project.
In list 2 I want to show the day by day assignment for each staff member...