Dear,frnds
I WANT TO KNOW THE USES OF "VLOOKUP AND HLOOKUP" DURING PROFESSIONAL LIFE OF DURING DATA ANALYSIS OR REPORTING
2 Replies
CA Saurabh Khatri
(Business)
(73 Points)
Replied 16 June 2014
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
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 12 September 2014
Imp..refer for reverse/backward lookup formula: /forum/reverse-backward-vlookup-advance-excel-function-305491.asp
Recent Topics
- Reporting in gstr9 of ITC of Previous year reverse
- Tax on Reimbursement of House Rent
- MAHARASHTRA CHARITY COMMISSIONER WEBSITE
- Explanation 3 to section 11(1) read with section 4
- Ammendment in Partnership On Death of Partner and
- TDS Provisions applicability Tax Audit Individual
- NAME CHANGE OF HUF
- Advisory for Reporting TDS Deducted by scrap Deale
- Section 194 J Technical Service/Professional Servi
- Solving of Export Related Problems
Related Threads
CAclubindia
