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
- Itr 1 processing
- Off Market debit and credit transaction
- ITR 2 Short Term gain & Long term gain
- Reporting Income under Section 44ADA
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- Share accounting-->fifo - capital gain - period as per fifo?
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- ITR returnFY25-26
- Short Term Capital gain on shares bought and sold after 2018 onwards
- ITR validation error - Balance sheet is not filled
- Registration as Authorised Representative of minor
- Article ship defecit
- Bank Accounts in Balance Sheet for ITR 3
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
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
