Vlookup function in excel
This query is : Resolved
14 April 2011
Hi,
can u please explain with a small example what is a vlook up function.Please also let me know the definition and the situation in which this function is being used.
can u please explain with a small example what is a vlook up function.Please also let me know the definition and the situation in which this function is being used.
Praveen Bajaj
(Expert)
15 April 2011
If you need to pull a data-point corresponding to a particular data point, you can use v-lookup. For instance, if you have a sheet with names and age of 200 people. From this you want to pull the ages of 5 particular people in a different sheet, you can use v-lookup.
Download this file for an example and let me know if you have any doubts
https://rapidshare.com/files/457533696/Vlookup_demo.xls
Download this file for an example and let me know if you have any doubts
https://rapidshare.com/files/457533696/Vlookup_demo.xls
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
- Tax on Amount transferred in HUF Account
- Nursery business
- Working on Gold wastage during Melting of old gold jewellery
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- TDS on Dashcam rent and allied services
- GST input credit on commercial property
- Gift to nri relatives residing in usa
- Section 269ST applicability for capital introduced by partner to his partnership firm
- ETDS return q4 25-26
- GSTR-9C filing
- Royalty payments to the Mining Department for procurement of murum - GST input
- HOW TO ADJUST CREDIT NOTE AMOUNT ?
- Import Order Cancelled.
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- 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
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
