Multiple formual or array to Auto-fill the list

[amanp786]

This is challenging for me I really hope you guys can help. In sheet 1 there is list of customer with the Amount, fees, lawyer fees and more. In Sheet 2, I have the master list which ONLY has the distributions of lawsuits filed for the customers from sheet 1. I am trying to create new sheet 3 where it will auto-fill year, # of lawsuits filed, amount for EACH year and also do dividing/multiplying.

I have done an example with instructions in the file

I am not sure the best way of doing this. I have attached the Excel file, its just a sample but my original data is in thounsands. I don't want to do it manually because I want to learn and expand my knowledge on using multiple formulas or/and using arrays if possible.

If you get confused if don't hesitate to ask me questions.

Thanks guys.

[amanp786]

Anyone wanna give it try??

[Tony Valko]

Anyone wanna give it try??

You haven't explained what you want to do?

[amanp786]

You haven't explained what you want to do?

It is in the Excel file that is attached

[Tony Valko]

It is in the Excel file that is attached

In that case I'll have to pass.

Good luck!

[amanp786]

If someone can look at it and advice me where/how to start it will be great