I have two worksheets. They are both identical with an exception of on column
which is on my summary table. The tables are as follows:

data table: job_no; patient; hospital; fault; req_date; rec_date;

This table contains all the records from every job we have received.

summary table: job_no; patient; hospital; fault; req_date; rec_date; ACTION;

This table contains a sample of the data in the 'data table'. I add actions
to each job on this table.

I need to know how to create a lookup so it will take the ACTION from the
'summary table' and add it into a new column in the 'data table'. it should
only add the action if there is an action and the jobs_no in both tables
match as this field is unique.

any help would be appreciated