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

Hi Jawnmallon,

I think this is what you want!

In H2: =VLOOKUP(G2,A2:C20,3,0)
In I2: =GETPIVOTDATA("ORDER_ID",$D$1,"CREATED_USER_LOGIN",G2)

You could even set G2 up as a data validation list so that you get a "drop down" list of the names in column A.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".