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.
http://www.youtube.com/watch?v=KXhM-wBM7U4
http://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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- RCM INVOICING FROM NOV-2024
- GST Regis.
- Confusion around Form 26QB fields
- Tds on building rent monthly
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- As per schedule III of balance sheet how to pass journal entry
- Is correct way to find out capital of individual on 31st March
- Individual capital equal to which assets of balance sheet
- 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 ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
