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
- About TDS & Income Tax
- Pass word to open justification report for Q1 for FY 2026-27
- Section 194JA & JB Income which ITR Form to use
- PPF interest-As Exempt Income disclosure
- Scrutiny and reopening of past returns
- F & O PROFIT REPORTING FOR AY 2026-27
- Booth for sales promotion
- Type of Capital Gain
- VALUATION OF PRIVATE LIMITED COMPANY SHARES
- Average Cost Of High Quality Diamonds
- TDS on Rent received on redevelopment of building
- Tax on Deemed Capital Gain
- 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
