Answer Posted / shivashanker kannoju
Vlookup is used for get the related data from the existed
file with uniques field in the both files
we have Two types of lookups
vlookup
Hlookup
Vlookup is used for veritical comparison
Hlookup is used for horizental comparision
| Is This Answer Correct ? | 22 Yes | 1 No |
Post New Answer View All Answers
WHEN IN ADJUST. GIVEN THAT THERE IS VALUE OF RS...., OBSOLESCENCE STOCK INCLUDED IN CLOSING STOCK RS.......,WHAT IS THE PROPER WAY TO SHOW IN INCOME STATEMENT AND POSITION STATEMENT.
What are the objectives of accounting
A company produces and sells 12500 units of Commodity X at Rs 50 each. The variable cost of the production is 20 % of selling price. Fixed cost being Rs 100000 per annum. Calculate the PV ratio and BEP if. The selling price is reduced by 5 %. Fixed cost is increased by 2 lacs
A crushing unit blasted 1650Mts in the month of March 2009. The rate of Royalty to be paid is rs 35/- Per MT. Advance royalty was paid rs 250000/- on 1-3-2009. pass journal entries from the advance royalty
How to maintain Purchase Orders ? Please explain by proper format.
About Funding Working Capital to a Company? A company Turn over is 12 Cr, but in the bank statement credits per month is more that 3 Cr? how this could happen? awaiting your views?
I have a existing Oracle applicttions and need to bring one of the new business on it. The new business will use GL, AP and FA. We will use existing COA. This business will have 3 sets of books (1- tax book, from April to March; 2- Primary book, from July to June; 3- Reporting book, from July to June); All books will have same currency; HOW DO I TRANSFER DATA FROM PRIMARY BOOK INTO TAX AND REPORTING BOOKS EVERY MONTH OR ON WEEKLY? IS THERE ANY STANDARD ORACLE PROCESS WHICH CAN BE SCHEDULED? THE REPORTING BOOK WILL HAVE DIFFERENT DEPRECIATION METHOD SO HOW DO I NOT TRANSFER DEPRECIATION FROM PRIMARY TO REPORTING BOOK AND DO SEPERATE DEPRECIATION IN REPORTING BOOK FOR THE SAME ASSET THAT IS ALSO IN PRIMARY AND TAX BOOK?. HOW DO I APPROACH ON SETTING THESE NEW SETS OF BOOKS? Thanks, KK
I have complited my ERP course in FICO module. Now I want to work in ERP package. Please suggest me how I will apply for the organisation works in ERP environment.
What problems might be encountered if there were no accounting standards?
what do you mean indirect expanse in trading business?
what are the new rules of central excise ?
plz tell me short cut method in maths for clerck post in bank
describe the most complex challenge that you have faced and how you managed it
Short Answer on _________Financial accounting
Do v call director in the partnership firm?