Hey guys hopefully someone out there can help and explain something for me.

Basically I have a weekly report sheet from work with all colleagues and their performances.
I am wanting to pull the information from there (which will be in the first sheet) and put into a sheet to correspond to the department they work in (sheet 2)

I then want those results to be compared to a separate sheet that will hold actual targets (sheet 3) and turn the background green or red accordingly.

The report shows around 40 colleagues and around 20 results per colleague.
There are also 4 departments to split them into.

I was using VLOOKUP to grab the Colleagues data (as each colleague has an individual number identifier)
When trying to then match that lookup with the targets page is where I fall short.