Dalai Pookah
New Member
- Joined
- Jul 14, 2016
- Messages
- 11
I know there's a simple solution to this, but my mind is blocked. I have a spreadsheet with 5 cells of data in a row. Based on these 5 cells, I generate 4 calculated values.
I have another spreadsheet with a list of 50 situations. Each situation has cells that correspond to the 5 cells of data (above). I would like to apply each of the 5 sets of data to the 1st spreadsheet and populate the remainder of the rows with the 4 associated calculated values.
It's not a normal lookup function as the 1st spreadsheet changes dynamically with the data.
A better analogy would be if I had 50 loans with different maturities, interest rates, initial amounts. I have a sheet that calculates an amortization table for the loan. I then would like to update my sheet of 50 loans with, say the principal balance, principal paid and interest paid in 2015.
I've tried a number of approaches and know it must be elegantly simple, but for the life of me I don't know what it is.
Thank you,
I have another spreadsheet with a list of 50 situations. Each situation has cells that correspond to the 5 cells of data (above). I would like to apply each of the 5 sets of data to the 1st spreadsheet and populate the remainder of the rows with the 4 associated calculated values.
It's not a normal lookup function as the 1st spreadsheet changes dynamically with the data.
A better analogy would be if I had 50 loans with different maturities, interest rates, initial amounts. I have a sheet that calculates an amortization table for the loan. I then would like to update my sheet of 50 loans with, say the principal balance, principal paid and interest paid in 2015.
I've tried a number of approaches and know it must be elegantly simple, but for the life of me I don't know what it is.
Thank you,