Avatar of recycleaus
recycleaus
Flag for Australia

asked on 

Complex Lookup Formulas

Hi, I am hoping someone can help me with 3 complex look up formulas please.

Attached is a file with 2 active sheets. The are 3 columns I am trying to fill in the 'SUMMARY' sheet based on data in the 'Transactions' sheet.

All lookups are based on the Account # (which is 'Acc #' in the 'SUMMARY' sheet and 'accno' in the 'Transactions' sheet).
1. 'Trans Count' - # of transaction listed in the 'Transactions' sheet (so in the case of account 35 there is 3 transactions)
2. 'Last Trans Date' - date of the most recent transaction listed in the 'Transactions' sheet (so in the case of account 35 it is 1st Aug 2016 - this is column D)
3. 'Last Trans Value' - value of the most recent transaction listed in the 'Transactions' sheet (so in the case of account 35 it is $569.8 - this is column N)

If someone is able to put these calculations directly into the spreadsheet I have attached I would be extremely grateful!

Thanks a lot
Troy
Amalgam-separator-rebate-informatio.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon