Hello,

I have a list of workers that carried out multiple actions on a given day.
What I wish to do is a apply the position they were assigned to on a given
day to every action. I have a table of actions by date and worker and a
table of positions by date and worker.

For example:

Table 1 Actions

Brian 22/4 cleaning
David 22/4 washing
Brian 22/4 gardening
David 22/4 running
Sally 23/4 cooking

Table 2 Position

Brian 22/4 Supervisor
David 22/4 Assistant
Sally 23/4 Trainee

In table 1 I wish to assign to column D the position. Therefore for the
entries for David should have assistant and Brian should have Supervisor in
the 4th column table 1.

Any help would be greatly appreciated.

Thanks