banner_ad

CAclubindia Articles


Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108116 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



Understanding AS 22 - Deferred Taxes

Posted by Himanshu Kalra 15 September 2014 109848 Views

AS 22 is considered a tricky accounting standard and rightly so. This article is an honest effort to explain the same it in simple words.Deferred tax means providing for the differences between accounting income an



In Pitru Paksha memorizing ancestors & their property taxation

Posted by CA Umesh Sharma 15 September 2014 8859 Views

Karniti Part 54:In Pitru Paksha memorizing ancestors & their property taxation.Arjuna (Fictional Character): Krishna, the fortnight starting from 9th September to 23rd September is called as pitrupaksha or shrad



Do's & Don'ts for dealing in a commodity market

Posted by rohit natani 15 September 2014 6545 Views

DOS AND DONTS FOR DEALING IN COMMODITY FUTURES Do`s Don`ts 1. Read the FMC/ Exchange guidelines and circulars available on the websites of the Exchanges



Banker's Legal Guide to dealing with Phishing scams in India

Posted by Guest 13 September 2014 7706 Views

Online banking revolutionized banking transactions, whereby money could be transferred at a single click. It has been a time saver and has been an extremely convenient method to undertake commercial transactions. However, it has lead to a slew of lit



Procedure for commencement of Business under CA 2013

Posted by Ankur Garg 13 September 2014 16147 Views

Under Companies Act 2013, the date of incorporation of a company cannot be the date of commencement of business. From the point of commencement of Business companies may be divided into 2 categories: Public and Private Companies not having Share Cap



Why do you need a professional advisor?

Posted by CA DHIRAJ SATNALIKA 13 September 2014 6334 Views

If you do your own business or if you are a tax payer, have you ever wondered whether you should turn things over to a professional advisor? This article attempts to shed some light on this topic and provide you with some things to think about so you



CA, CA and CMAs wait for the right job opportunity

Posted by Ankur Garg 13 September 2014 30792 Views

Dear Students, The problem of scarcity of job is not a new problem in the life of professionals like CA, CS or CMA. Many qualified professionals are waiting for right job opportunity. Some time back, in CCI, I have come across various threads regardi



Order u/s 147 without disposing objections to be quashed

Posted by CA Paras Dawar 12 September 2014 18638 Views

Reassessment order u/s 147 without first disposing off the preliminary objections raised by the assessee can not be sustained and is this liable to be quashedSupreme Court in GKN Driveshafts (India) Ltd. vs. ITO & Ors. (2003) 259 ITR 19 had dev



How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 41933 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




Popular Articles





CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news

CCI Articles

submit article



Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details