Forum Discussion
Solved
Vlookup to find multiple variations of a text string
Hi, first time post here so bear with me! I am trying to create a worksheet that displays a list of shift types with names of staff allocated that shift over the period of a week. I can do this ...
The catch might be that 'day' is a relative reference to the indices 1,...7 above the table. To get a fresh value for each column, the array formula is applied to a single column and then copied across to give a set of 7 array formulas rather than one single array formula.
Not sure I follow but cant understand why you fix on my example works but it wont work on the real data.
Was wondering if there is an issue with shifts in the source data that don't appear in the left hand column of sheet2?
There are about 50 core shifts and while these might appear in the source data I haven't yet been able to ensure that they all appear in the shift column on sheet 2.
Was wondering if there is an issue with shifts in the source data that don't appear in the left hand column of sheet2?
There are about 50 core shifts and while these might appear in the source data I haven't yet been able to ensure that they all appear in the shift column on sheet 2.