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

bryce126

New Member
Joined
Nov 19, 2015
Messages
8
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. In some other cases, the condition will be "if the name matches this other list AND transaction type is subscr_payment" Thanks!

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

Data slightly censored but I hope I've provided enough:

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
 
Last edited:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top