Compiled data in a sheet

[Manish Kumawat]

Hi everyone

I have an excel with data name sheet and where i have all the General insurance companies and i have also the data in different sheets with name year now i want to compile all the figures in data sheet. i am not familiar with address and match function.
if i use vlookup i have to do it again and again.

Please help if is it possible i have done what i want in sheet "Data" B5

Many thanks in advance
Manish

 

[Pavan.Sada.PS]

Hello Manish,

Have a look at the attached file. Formulas are not dynamic in nature as the data in the different sheets (Worksheet names are not in the stipulated format) is not organized properly. Also yellow highlighted cells in 2005-06_2006-07 sheet have been changed to match as per the DATA sheet.

Regards,
Pavan S

 

[Manish Kumawat]

Thanks Pavan S i was not familiar with offset function.. i am just checking it and will bother you again if i had a doubt