Does this require VLOOKUP?

I developed an extremely helpful and useful Excel sheet thanks in large part to the help I've gotten off of this site.

In fact I've fixed about 90% of what I've wanted to fix on the project, with only one thing left (that I can see so far).

In the uploaded you'll see a tab labelled WARR JOBS. The purpose of this sheet is to keep a tally of which Techs end up taking warranty jobs as they don't get paid for them. My goal is to spread them out as evenly as possible. Previously I've always had to just cut/paste the information automatically. Then H13:H21 would just run this formula to count how many occurances I had entered manually:

=COUNTIF(C8:C481, G21)

G13:G21 are the Techs' initials.

I've recently entered this code into the cells next to that to count directly from the sheet labelled COMPLETED WORK:

=SUM(IF(('COMPLETED WORK'!$H$2:$H$5979="WARR"),IF('COMPLETED WORK'!$G$2:$G$5979=G21,1)))

This looks for the occurances of the tech's initials in G21, then counts how many warranty jobs he's completed in the sheet COMPLETED WORK.

So those I have figured out. What I'd like to do (and the reason for the thread title) is that the information in columns B - D should get posted automaticlly. This is what I'd like to have happen:

If a Warranty is completed then:
'WARR JOBS'!A = 'COMPLETED WORK'!B
'WARR JOBS'!B = 'COMPLETED WORK'!D
'WARR JOBS'!C = 'COMPLETED WORK'!G
'WARR JOBS'!D = the month/day from 'COMPLETED WORK'!I

From there I could just use the first code I posted to sum up the occurances and know it is accurate.

Thank you in advance for your help!

Hi mealstrom
See attached. Is that what you want??? Would also like to know my mistakes there...

try this all yellow cells have formulas and i changed h13:h20 to a simple countif
edit added second version with extra helper columns on data sheet instead ,wasn't sure which column you were getting date from so each version references a different column for date

Oh wow, that second one is EXACTLY what I was looking for. It even ranks them (which was going to be my next question).

Thank you for the help. I'll go list this one as resolved, but I might have a few questions on the exact mechanics of it.

that was probably my fault copying things from a "live" version to my saved one, sorry