using V look up and H look up
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
16 May 2010
Anyone can guide me on how to use V look up and H look up in a detailed manner. Plz give me step by step answers. Its very urgent. Thanks for everyone who replied.
17 May 2010
V look up function is used to find a cell value in another sheet.
Example Let us on sheet 1, you are given the following values:
Name of Student Marks
A 50
B 70
C 80
On another sheet you want to look up marks of a particular student C
C = Vlookup(Cell refrence of "C" in this sheet, Cell reference of the two column of previous sheet,2,false)
Then you will get marks obtained by C
Example Let us on sheet 1, you are given the following values:
Name of Student Marks
A 50
B 70
C 80
On another sheet you want to look up marks of a particular student C
C = Vlookup(Cell refrence of "C" in this sheet, Cell reference of the two column of previous sheet,2,false)
Then you will get marks obtained by C
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
- Exiting partner in partnership firm in gst portal
- CLOSING STOCK QUERY
- Gst on travel by air for business purposes
- CASH GIFT FROM BLOOD RELATIVE
- TDS offline utility
- Due Date Clarity
- Error in uploading Form 10BD
- NRI INSURANCE ADVISOR
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- ITR-3 File/Error Found
- Missed TDS
- Query regarding Item 61/62/63 vs Item 64 in ITR-3
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
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
