Getting missing data from one report into another report...

[vlookupabyss]

Need to get data from one report into another report:

Two reports – one payroll report being used to accurately display the
correct number of people in a retail branch, second report shows only those
in each branch who have completed e-learning or are busy doing it. Second
report is generated by an LMS and only shows those busy with or who have
completed training.

Common variables are employee number and the retail office number (each
employee has its own unique number and each office/retail branch has its own
unique number)>>> have tried to use the retail office number (which is on
both payroll and second report) to get the extra names of those who have not
done e-learning via vlookup but doesn’t work – as every person in a retail
office shares the same office retail number!!!

Is there a way that I can get those people who are recorded on the payroll
report as being in an office who are not yet on the training report onto the
training report?!?!

Many,many thanks for any help...

 

[Roger Govier]

Hi

You could insert a new column A
In that column create a Concatenated value
=B1&"|"&C1

where B1 holds Employee number and C1 holds retail Store number (change
reference to suit.

Then do your lookup of the concatenation of Employee and Store against a
table that includes the new column A

 

[vlookupabyss]

Thanks for the help. I have another question, how can I get the data of those
who have not completed training (their names) listed on the same column that
lists the names of those who have completed training on the report drawn from
the learning management system?? Basically the goal is to create a single
report listing those who have and haven’t completed training.

 

[Roger Govier]

Hi

I'm sorry, I don't follow what you mean.
If all the names are in one column, then that would be exactly the same as a
list of all Employees.
You must have at least 2 columns,
Either
One column of Names who have had training, and one column of names who have
not had.
Or
One column of all Employee names and a second column with Yes or No against
the name.