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 Regis.
- Inventory of finished goods
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- Disallowance of Section 43B(h) to sez units
- Applicability of Ind As to associate of associate
- Sale of property furniture sale
- Confusion around Form 26QB fields
- Bogus purchase treatment for it act gst dealer
- Gst input for FY 23-24
- Company registration : Rental agreement or NOC?
- Company Incorporation - CA and directors signing from different states
- Filing of Form 10BB instead of Filing Form 10B
- HSN Details in IFF/GSTR-1 & in GSTR 9
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
Trending Online Classes
CAclubindia
