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 42327 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 108140 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 13572 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 50239 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 12947 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 18005 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
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
08 October 2026
Account Executive

Elite Taxation

New Delhi

CA Foundation

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details