Need a help regarding Excel Formula

[lahiruudara]

mata dana ganna ona mama me attach karala tiyena eke A3 cell ekata formula ekak danna ona A1=2009 wenakota A3=I3 wenna atarama A1=2010 wenakota A3=J3 wena atarama A1=2010 wenakota A3=K3 wage Condition ekak danne kohomada kiyala.

Eka danna kenek innawanam kiyanna. Loku help ekak.

 

[Mindada hee sara..]

Menna mama sheet ekema kala. Oya reference and lookup kiyana formula set eka balanna. thawa monawahari clear karaganna oone nam pm to me.

http://www.mediafire.com/?nkztw1gcjod

 

[lahiruudara]

Menna mama sheet ekema kala. Oya reference and lookup kiyana formula set eka balanna. thawa monawahari clear karaganna oone nam pm to me.

http://www.mediafire.com/?nkztw1gcjod

thanks machan.
mamath ekak hoya gatta if condition eken


oyage reply eka dakke passe. dan e file eka site eken delete karala. apahu danna puluwanda?