complete data row

[thesis07]

Hey,
I hope you can help me with the following problem. I have got a intra-day data series (per second) of an index. It looks like that:
date and time (Per sec) index
04.03.2014 08:00:00 22608,2
04.03.2014 08:00:01 22609,0
04.03.2014 08:00:02 22610,0
04.03.2014 08:00:03 22610,0
04.03.2014 08:00:04 22611,0
04.03.2014 08:00:07 22612,0

And now I want to set up a new datarow which consists of an index price for EVERY second, meaning:
08:00:00 22608,2
08:00:01 22609,0
08:00:02 22610
08:00:03 22610
08:00:04 22611
08:00:05 22611
08:00:06 22611
08:00:07 22612
So you see, for the seconds were I did not have any indexprice in the beginning I want to use the one before (e.g between second 4-7 I did not have any index value, so I want that for the seconds 4,5,6 the index value of 4 is placed). I have tried to do it wiht a WENN (UND) function but it did not work - so I really hope someone can help me. Thanks a lot=)

[mrice]

Could you do this by creating a column with every time value and using VLOOKUP with the approximate match parameter set to TRUE?

[thesis07]

Hey - Thanks for your answer, but maybe could you give me more precise steps. I have tried it but it did not work so far. Thanks a lot=)

[Vikas_Gautam]

got the answer bro...

check the attachment...


Don't forget to click *

[alansidman]

See attached

[thesis07]

Hey, thanks a lot for your Excel files. I have tried to use it with my data and in the beginning both of your suggestions seem to work but unfortunately they donīt I have copied the Excel files - maybe you could have a look on it and tell me what I did wrong)Thanks so much.Fantastic Lookup (1).xlsxBook2.xlsx

[boopathiraja]

Please check out the formatting from b1:b6, vs b9:b17 the results where arrived from b1:b6 ,