MS EXCEL
This query is : Resolved
26 November 2009
Pls. explain OR provide about use of
"vlookup" formula in excel
"vlookup" formula in excel
27 November 2009
You can bring the value from the other excel file to the current file by just looking for the common values in the other file file.
Remember that the cell format for the common value in the both file should be same, for expample numbers, text etc.
In the simple langauge the formula is explained as under;
=vlookup(common value in the current file,define data range in the other file,number of colum in which related data exists in other file,0)
0 is to be put for the search and bring numerical values. You can also use True/False logic.
Remember that the cell format for the common value in the both file should be same, for expample numbers, text etc.
In the simple langauge the formula is explained as under;
=vlookup(common value in the current file,define data range in the other file,number of colum in which related data exists in other file,0)
0 is to be put for the search and bring numerical values. You can also use True/False logic.
28 November 2009
The formula expained by Mr. Kishanlal is correct. Incase, you want to understand with an example, kindly send your mail id on rinkurahul@indiatimes.com. I will send you an actual expample for the same.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst registered proprietorship firm
- Price inclusive or exclusive of GST while made entry in P& L Account
- TDS Challan - change of FY 2025-26 to TY 2026-27
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Minimum tax payable to file Updated return
- Change Of Karta In Case of Death
- TDS on purchase of under construction property from a reseller
- SALARY CAN BE CAPITALIZE
- GST Intimation due to Government took possession of Business Premises under PPE Act
- UDIN ISSUE
- Non filing of I T Returns
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
