Compare value from one list against another list and show a row of data

[bryce126]

Hello! I have a tab which will pull data directly from Paypal, including names and transactions and amounts. I need to compare this growing, dynamic list against a static range of clients on another tab. If a name from the dynamic PayPal list matches the static client list, I need to pull the PayPal row of information into a growing list in a new place. I have attached screenshots. "Data Drop" is the PayPal dynamic page, and I have put a red box around a sample name that matches to another name in the static list. Thanks!

My thoughts are using INDEX MATCH as an array formula with some conditional criteria, but I can't figure out the syntax.

https://www.dropbox.com/s/ni1kkrr67ni83id/TSA_Accounting_Test_-1.jpg?dl=0
https://www.dropbox.com/s/v8hxzdvh2pq3c9o/TSA_Accounting_Test_-2.jpg?dl=0

Thank you!

 

[BrianJN1]

One of those lists has sensitive information!

 

[bryce126]

One of those lists has sensitive information!

Yeah its not so bad. I left out anything very important. Can you help though?

 

[BrianJN1]

If the email addresses that I see are genuine, as they appear to be, then I suggest that you remove that image and repost without what might be seen as "sensitive". I am not going to consider this further.

 

[bryce126]

If the email addresses that I see are genuine, as they appear to be, then I suggest that you remove that image and repost without what might be seen as "sensitive". I am not going to consider this further.

Those two links are now broken and these two new links have blurred sensitive information. Thank you.

https://www.dropbox.com/s/yswtn7l6lbs17ew/TSA_Accounting_Test_-1.jpg?dl=0
https://www.dropbox.com/s/6jtwzysns7k74je/TSA_Accounting_Test_2.jpg?dl=0