Dear,frnds
I WANT TO KNOW THE USES OF "VLOOKUP AND HLOOKUP" DURING PROFESSIONAL LIFE OF DURING DATA ANALYSIS OR REPORTING
RISHIKESH KUMAR (ARTICLE) (69 Points)
15 June 2014Dear,frnds
I WANT TO KNOW THE USES OF "VLOOKUP AND HLOOKUP" DURING PROFESSIONAL LIFE OF DURING DATA ANALYSIS OR REPORTING
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!)
(33511 Points)
Replied 12 September 2014
Imp..refer for reverse/backward lookup formula: /forum/reverse-backward-vlookup-advance-excel-function-305491.asp
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
