I am new to Excel programming and formulas and im not sure how to best approach this, I have a large spreadsheet (500+ Row) that contains data as shown below. I am looking for a way to automate or formalise the following actions:
Take the date value in the date column, and match it to the corresponding Column value, eg, 1/10/2013 matches Column OCT-13. Once determined, I want the price value put into that cell of the corresponding row. I hope the example below clarifies this because I dont know how to explain it . Thanks for any assistance given.
Take the date value in the date column, and match it to the corresponding Column value, eg, 1/10/2013 matches Column OCT-13. Once determined, I want the price value put into that cell of the corresponding row. I hope the example below clarifies this because I dont know how to explain it . Thanks for any assistance given.
Price | Date | OCT-2013 | NOV-13 | Dec-13 | Jan-14 |
5 | 1/10/2013 | 5 | |||
6 | 1/1/2014 | 6 | |||
9 | 1/11/2013 | 9 | |||
15 | 1/12/2013 | 15 |
Last edited: