Hello all,
I tried searching for what I'm trying to do, but the buzz words keep bringing up scenarios that aren't fully solving my issue.
Please see the attached spreadsheet for reference.
On the 'Analysis' sheet, in cell I5, I am trying to lookup 5 values on the another sheet. It needs to be a multi-part lookup.
First, I need to look up the sheet that the data will be on. The sheet will be called what is in cell A5. In this case, it is 'SPY'.
On the 'SPY' sheet, I need to look up the stock's price from the last day in reference, which is found in cell A1 on the 'Analysis' sheet.
Next, I need to also look up the stock's price from the previous 4 trading sessions, which will be the 4 rows above this.
Lastly, I need the average of all 5 values.
Can anyone please help me with this?
Bookmarks