Interpolation, changing frequency of data

**George.ca** · 04-03-2014, 02:10 PM

Excel.jpg

Hi I'm trying to convert a series of annual data into quarterly data. Taking column O (the annual data) as the data for first quarter of the year, and column P as the quarterly growth in that year, is there a formula that can compute the quarterly data in column T? Thanks a lot!

**MrShorty** · 04-03-2014, 02:43 PM

It looks like you have the formula correct, but you need a formula that will be easier to copy down the list. I would probably use one of Excel's lookup functions: http://office.microsoft.com/en-us/ex...149.aspx?CTT=1 VLOOKUP() is probably the first one people would suggest. Something along the lines of =G2*vlookup(E2,$B$2:$C$50,3). the VLOOKUP() function will search column A to find the year in column E, then return the calculated Growth rate (column C) for that year.