How to use vlookup formula
This query is : Resolved
CA Mehta Ankur N.
(Expert)
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
- Late Filing Fee Waiver for Q1 Form 144 (Earlier 27Q) – Transition to Income-tax Act, 2025
- Ito add credit side of bank
- GSTR9 Annual Return
- Employee secondment
- Form 144 TDS Return Validation error
- GST ITC as per notification 12/2023- central tax
- Capital gain on commercial property and investment in residential property
- Rent agreement of House of deceased person
- Applicability of tax on invoice
- Positive Balance in RCM Liability/ITC Statement – Commercial Rent RCM – Guidance Required
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- 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
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- 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
