How to use vlookup formula
This query is : Resolved
01 July 2013
in excel what is the process of vlookup in excel sheet
01 July 2013
start from
=VLOOKUP(Lookup Value,Table Arrey,col index number,0)
Lookup Value = is the value to be found in the first column of the table (Data field which is to be compared)
Table arrey = is table which contains data which is to be compared
Col Index number = column number of the table which is compared to query (if value is in column c then enter 3, if it is in column d then enter 4, etc)
Formula should be used in primary sheet with which data to be compared
=VLOOKUP(Lookup Value,Table Arrey,col index number,0)
Lookup Value = is the value to be found in the first column of the table (Data field which is to be compared)
Table arrey = is table which contains data which is to be compared
Col Index number = column number of the table which is compared to query (if value is in column c then enter 3, if it is in column d then enter 4, etc)
Formula should be used in primary sheet with which data to be compared
Message likes :
1 times
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 ITC REVERSE
- Fixe term employment
- Is any professional CA is here please reply
- EXPORT BILL UNDER LUT FREIGHT CHARGE INCLUED IN INVOICE IT LIABLE TO TAX
- Gift Received from nonblood relative
- Section 50-fixed asset-->building ceases to exist
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Putting a heading on received mail
- Tax Audit u/s 44AB for Transport Business A proprietorship is engaged in transportation business and
- 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
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
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
