Hi Excel Gurus,

I have problem... I need to get the price of a value which was between a certain period mentioned on the top row....

You can check the excel sheet i have attached.....

I need to update the "second data".. with the help from "first data"
Data.xlsx
Eg.. 680000009 had a value 0f 23 in jan 10 but changed in feb 10 so it should give me the change as well...

Waiting for your answers....

Thanks a ton..

HJA