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
deepali agarwal
(Expert)
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
deepali agarwal
(Expert)
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
- Late Filing Fee Waiver for Q1 Form 144 (Earlier 27Q) – Transition to Income-tax Act, 2025
- GST input credit on commercial property
- GSTR-9C filing
- GST ITC as per notification 12/2023- central tax
- Urd purchase entry in tally prime
- Form 144 TDS Return Validation Error – Mandatory Fields
- IMS (import of goods) ITC related
- Gift to nri relatives residing in usa
- Royalty payments to the Mining Department for procurement of murum - GST input
- Capital gains in IT returns
- LLP audit and disclosure
- Subject: Legal Remedy for Removal of Income Tax Demand for AY 2024–25 – Charitable Trust
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- 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
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
