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
- TDS 194-T applicability
- Fixe term employment
- Is any professional CA is here please reply
- GST ITC REVERSE
- Putting a heading on received mail
- Reprocessing of rectification order AY 2025-26
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Consolidated financials
- Section 50-fixed asset-->building ceases to exist
- TDS on Complimentary "Desi Ghee and Gold Coin" Provided to KBC Contestants
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
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
