Match/VLookup/Index?

Hello all,
I am trying to match the names in column "A" with any exact matches in column "D" (which is a pasted result of a pivot table) and would like to display the matches in column "G" with their respective numbers (Total "C" vs. Promo "E") that correlate with each. I've highlighted the result which I would like to see.
Any suggestions?
Thanks in advance friends.

http://www.excelforum.com/attachment...1&d=1459917362

Total Row Labels Promo Total Promo
pblanchard 8 Amanda Glaspy 2 avance 77 42
jchristian 60 aglaspy 2
rchristian 49 Ashlie Brooks 1
dcouch 48 abrooks 1
jedgar 2 Autumn Vance 42
jhankins 105 avance 42
pjones 93 Debbie Couch 17
koliva 57 dcouch 17
landerson 4 Diana Bass 3
aglaspy 6 dibass 3
gglaspy 4
ehughes 96
kwatkins 15 Elaine Hughes 43
avance 77 ehughes 43
hhill 60 Greg Glaspy 1
sschroll 119 gglaspy 1
ketherton 2 Heather Hill 42
rstephens 33 heahill 42
Jennie Edgar 43
jedgar 43