Dear,frnds
I WANT TO KNOW THE USES OF "VLOOKUP AND HLOOKUP" DURING PROFESSIONAL LIFE OF DURING DATA ANALYSIS OR REPORTING
Menu
How will be uses of vlookup or hlookup
Replies (2)
Vlookup is the function that look the data verticely and Hlookup look the data horizontally.
Suppose there is 50000 rows of data and you want to get data of 2000 rows then you can't find each row data manually and use Vlookup function which will find the data of 2000 row.
Click on the following link to get further info
https://office.microsoft.com/en-in/excel-help/vlookup-HP005209335.aspx
Imp..refer for reverse/backward lookup formula: /forum/reverse-backward-vlookup-advance-excel-function-305491.asp
Recent Threads
- ITR-2 Payment Made but Status Not Updated
- Need help for ITR filing
- ITR Updated returns. Time limit for filing
- ITR 2 Processed and Refund Credited to Bank
- Freelancer or Salaried
- LTCG Tax & Indexation on Debt Mutual Funds Sol
- Section 45(5A) and 194IC with carry forward of tds
- Paid tax amount, CIN generated and challan downloa
- INTRADAY INCOME PRESUMPTIVE INCOME
- Clarification on Deemed Export Status for EOU-to-E
Related Threads
CAclubindia
