Hi All,
I have set up the following formula in Sheet 2 of my workbook:
=INDEX(Sheet1!$A:$Z,$A2+MATCH(OFFSET(Sheet1!$B$3,0,INT(COLUMN()/2)-1),Sheet1!$A:$A,-1),1+(COLUMN()-1)*0.5*SIN(0.5*PI()*COLUMN())^2)
This has been designed to find the stock price for the company in columns B to AFN of Sheet1 for the date specified in row 3 under the company name in row 2. It really is quite simple.
The formula is successfully returning the correct dates from the date column but wont return the corresponding prices. Instead, it is returning some weird date value.
I would appreciate if someone could have a look at the workbook and point out why it will not return the stock prices. The aim of the function is pretty obvious from the workbook and I am sure it will only require a slight tweak.
Please find attached a sample of my workbook.
I truly appreciate and assistance on this urgent matter!
Thanks
Ryan
Bookmarks