How will be uses of vlookup or hlookup

Dear,frnds

 I WANT TO KNOW THE USES OF "VLOOKUP AND HLOOKUP" DURING PROFESSIONAL LIFE OF DURING DATA ANALYSIS OR REPORTING

 

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details