Vlookup function in excel 2007
This query is : Resolved
17 March 2012
Dear Experts,
guide me how to do the vlookup function in excel 2007, i am trying to learn myself but the result is not coming exactly.
kindly guide me for the above.
thanks & regards
guide me how to do the vlookup function in excel 2007, i am trying to learn myself but the result is not coming exactly.
kindly guide me for the above.
thanks & regards
12 April 2012
type "=vlookup(select the cell which u want to lookup, select the range, select the column no which u want the result) then u will get the desired value.
Message likes :
1 times
22 August 2012
vlookup looks for presence of a value in another set of values. Assume the value are looking is A2 and you wnat to search this is another place where there are F1 to f100 then formula should be framed as under
=vlookup(A2,$F$1:$F$100,1,0)
=vlookup(A2,$F$1:$F$100,1,0)
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?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- TDS U/S. 194NF
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Tds on building rent monthly
- Import license renewal
- 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
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
