Hey Everyone!
I am trying to make my spreadsheet more dynamic . I need it to take into account new deposits into a trading account.
Hence, lets say I have an account balance of 5,000 USD, and I deposit a further 2500 USD in week 10. I need all of the data in the spreadsheet to multiply by a factor of 1.5 (5000*1.5= 7500).
For the most part I am fine. However i have hit one area that I am stuck with.
In the sheet named "Trades", You will find in column CH "Multi". I want this column to look at "Trade week (Rank)" in AQ and return the Multiplier value in Sheet Money management (Table 4) that corresponds to "Week" in the in Sheet Money management (Table 4).
Here is the example practically so its easy to follow: I have deposited 2500 in week 10 (as shown in the Money management sheet). This is a multiplier for 1.5 but only from week 10 onwards from Y29. Therefore, how do I get each cell in column CH to look into at the "Trade week (Rank)" (in Trades Sheet) and return the Multiplier (in Money management sheet) that matches with the week also shown in (Money management sheet).
I hope this is clear. I have been looking into index Match and V Lookups but cant seem to work this out.
This is the fomula I tried - =INDEX(Table4[Multiplier],MATCH([@[Trade week (Rank)]],Table4[Week],0))
I have attached the spreedsheet into a compressed folder. I have highlight key columns in purple.
Thank you!
Bookmarks