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: