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
- About TDS & Income Tax
- Scrutiny and reopening of past returns
- Tax on Deemed Capital Gain
- Type of Capital Gain
- Exiting partner in partnership firm in gst portal
- F & O PROFIT REPORTING FOR AY 2026-27
- Regarding ITR filing with more value than showing in AIS/TIS
- Booth for sales promotion
- Difference in GSTR3B system generated which is correct and actual Payment it asks
- GST ON TRAVELLING BILLS
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Taxation in the hands of Landowner under JDA
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
