V-look up
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
17 October 2012
how to you V-LOok up in excel sheet please provide me details
18 October 2012
V-look up allows you to look up values in a table that are listed in column format (how most tables are laid out), given another value (let’s call this the “key”). Excel also has a sister function called hlookup (h = horizontal) that can be used to look up values in rows.
Vlookup’s format looks like the following:
=vlookup(lookup value, table where values reside, column # where values are located, false)
Vlookup’s format looks like the following:
=vlookup(lookup value, table where values reside, column # where values are located, false)
Message likes :
1 times
18 October 2012
u can view the following tutorial.
https://www.youtube.com/watch?v=KXhM-wBM7U4
https://www.youtube.com/watch?v=KXhM-wBM7U4
Message likes :
2 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
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- STCG....................................................
- TAN for Partnership
- Treatment of Pension ?annuity returns on PMVY
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- Sales return eway bill
- Free lancer income
- Loan by Partnership Firm
- TDS related Query_Liquidated Damages
- Long Term Service award taxability in hands of company
- Gst invoice numbering and delivery challan numbering
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
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
