Lets say that I want to enter employee names as values into an excel table of date (first column) vs rostered shift (header).
I'd like to be able to autofill a table on another sheet, with date (column) and employee (header), and now the shift as a value.
See linked image for more explanation.
I've tried various combinations of Index, VLookup, Match and Column. In particular, I'm struggling with identifying a row in Table 1 by the "row header" ie the date.
Is there a way to do this within Excel? A way that keeps it to a table structured reference?
I think that I managed to figure it out:
With the cells under the employee's names using:
Any further advice or improvements appreciated