Linking sheets to fetch transactions from sheets to another
I have created two sheets. One sheet contain basic data about customers such as account number, loan amount etc and other sheet list transactions of all customers in chronological order. I have created third sheet to allow me see report of each customer in similar fashion like a bank statement. I am able link this sheet to the first sheet to display basic information by using VLOOKUP function. Now I select/type account number of desired customer and corresponding information is displayed.
However, I need guidance regarding linking this sheet to second sheet to fetch transactions of only desired customers. I have tried little bit through VLOOKUP function but it only displays first transaction.
Please me suggest some ways to accomplish desired task.
|