CAclubindia Articles


How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 42018 Views

In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get



Indirect Foreign Investment or Downstream Investment in India

Posted by Ankur Garg 12 September 2014 42325 Views

Guidelines for calculation of total foreign investment i.e. direct and indirect foreign investment in Indian companies is primarily governed by Press Note No 2 (2009 Series) issued by Ministry of Commerce & Industry, Department of Industrial Poli



Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108138 Views

Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab



Interview with tax audit report petitioners

Posted by CA Sudhir Halakhandi 11 September 2014 13571 Views

The Mid-year introduction of New formats of Tax audit reports and further extension of date of Tax audit report without extendin



Excel function VLOOKUP

Posted by @VaibhavJ 11 September 2014 50238 Views

1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of



Start Up's beware: Every year start-ups lose more than US $3 billion

Posted by Paras mehra 10 September 2014 12945 Views

Raghav Raj Raman, IT software engineer, with his friend started a business of providing designer, developer consultancies to various clients in India and abroad. They are skillful enough but still they are not able to earn much. Therefore, they decid



Cenvat credit available prior to service tax registration

Posted by Bimal Jain 11 September 2014 12723 Views

Dear Professional Colleague,Service provider is eligible to avail Cenvat credit on inputs/ input services prior to Service tax registrationWe are sharing with you an important judgment of the Honble CESTAT of New Delhi in the case of Actis Adv



Reimbursement expenses arent includible in assessable value of services

Posted by Bimal Jain 10 September 2014 18004 Views

SERVICE TAX RECENT CASE LAWS Cenvat credit on inputs/ input services received by an output service provider prior to obtaining Service tax registration is admissible Actis Advisers Pvt. Ltd. Vs. CST. -Delhi-IV [(2014) 9 TMI 182 - CESTAT New Delhi]



Professional Courses to be pursued after or along with CA

Posted by Ankur Garg 09 September 2014 337326 Views

CA Dear Students, Many times in expert and forum section I have come across a question or career doubts what are the study options available along with Chartered Accountancy course or Company Sec



Important Company Law Procedures at one place Part-2

Posted by Ankur Garg 09 September 2014 21483 Views

Dear Professional Colleague In last few days I have written and uploaded different corporate law procedures under Companies Act, 2013 for fellow professionals. In this article you may find some of them at one place in to the point and crisp language.




Popular Articles





CCI Pro

CCI Articles

submit article



Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details