ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

How will be uses of vlookup or hlookup

RISHIKESH KUMAR (ARTICLE) (69 Points)

15 June 2014  

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!)   (33496 Points)
Replied 12 September 2014

Imp..refer for reverse/backward lookup formula: /forum/reverse-backward-vlookup-advance-excel-function-305491.asp


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  





Subscribe to the latest topics :
Search Forum:

Trending Tags