MS EXCEL
This query is : Resolved
26 November 2009
Pls. explain OR provide about use of
"vlookup" formula in excel
"vlookup" formula in excel
27 November 2009
You can bring the value from the other excel file to the current file by just looking for the common values in the other file file.
Remember that the cell format for the common value in the both file should be same, for expample numbers, text etc.
In the simple langauge the formula is explained as under;
=vlookup(common value in the current file,define data range in the other file,number of colum in which related data exists in other file,0)
0 is to be put for the search and bring numerical values. You can also use True/False logic.
Remember that the cell format for the common value in the both file should be same, for expample numbers, text etc.
In the simple langauge the formula is explained as under;
=vlookup(common value in the current file,define data range in the other file,number of colum in which related data exists in other file,0)
0 is to be put for the search and bring numerical values. You can also use True/False logic.
28 November 2009
The formula expained by Mr. Kishanlal is correct. Incase, you want to understand with an example, kindly send your mail id on rinkurahul@indiatimes.com. I will send you an actual expample for the same.
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?
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- GST ON EXPORT COMMISSION
- RCM INVOICING FROM NOV-2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- ITC EXCESS CLAIM + RCM NOT PAID...BOTH FOR FY 2020-21......PAID IN FY 2024-25....EFFECT
- 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?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
