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