ms excel vlookup qurrey
This query is : Resolved
20 March 2008
i want to know the formulae of vlookup in MS excel
21 March 2008
=VLOOKUP(E4,Mumbai!E:F,2,0)
or
click Fx and select vlookup a window will appear
now in frist column enter the cell of which similar data u are searching
in second column enter the range within which you want that particular data
in third typr the umber of range eg. from A to C it is 3(A,B,C)
in fourth simply type '0'
or
click Fx and select vlookup a window will appear
now in frist column enter the cell of which similar data u are searching
in second column enter the range within which you want that particular data
in third typr the umber of range eg. from A to C it is 3(A,B,C)
in fourth simply type '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
- STCG....................................................
- TAN for Partnership
- Sales return eway bill
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- Suggestions required for income tax filing-software (FY 2025-26)
- STCG FOR GOLD ETFs
- E way bill for tractors
- LTCG for Assmt year 26-27
- GST Registration Horse racing
- Section 43B(h) – MSME Invoice Paid Before Year End but After 45 Days
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
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
