Hello-
I have an excel workbook with two tabs. One data set including transactions with relevant data columns: Account Number & Amount. The second tab has a comprehensive export of data that I am trying to match with the first tab of data. The relevant data columns are included as well as a date in which the transaction was processed. I am trying to use a formula to return the transaction date on tab 1 if the formula find a match with the account number and the amount. The account number will have multiple matches since many items are posted to each account, however with the additional parameter of dollar amount it should narrow it down to one result. From that one result I would like the date from tab 2 to be returned on tab 1, this will be a data validation point for me to verify if the transaction was processed. One the data source tab I have named the data area for the various fileds: the entire table of data is "transaction_data", the amount is named "data_amount" which should match with tab one amount, account number is named "data_account" which will match with the account number on the given row but will have multiple matches in the source data, transaction date is named "data_date" which is the specific date I am trying to return in my data set in a new column that I created. Thanks!
I have an excel workbook with two tabs. One data set including transactions with relevant data columns: Account Number & Amount. The second tab has a comprehensive export of data that I am trying to match with the first tab of data. The relevant data columns are included as well as a date in which the transaction was processed. I am trying to use a formula to return the transaction date on tab 1 if the formula find a match with the account number and the amount. The account number will have multiple matches since many items are posted to each account, however with the additional parameter of dollar amount it should narrow it down to one result. From that one result I would like the date from tab 2 to be returned on tab 1, this will be a data validation point for me to verify if the transaction was processed. One the data source tab I have named the data area for the various fileds: the entire table of data is "transaction_data", the amount is named "data_amount" which should match with tab one amount, account number is named "data_account" which will match with the account number on the given row but will have multiple matches in the source data, transaction date is named "data_date" which is the specific date I am trying to return in my data set in a new column that I created. Thanks!