Vlookup, hlookup

Hello Dear Freinds, can anybody explain me in details regarding Vlookup, Hlookup, Pivot table with suitable illustration. As now a days this are the necessacity of an organisation. It would be great help if anybody provide me suitable examples and also let me know in which version of excel it is usefull. Thanks in advance.

Replies (2)

Hi,

if you are willing to spend some time seeing following youtube videos then pls see the following videos of vlookup, hlookup and pivot tables

vlookup1  vlookup2  hlookup  pivottables

Hello Bhavesh,

I am running a blog where I post on MS Excel options and formulas. In my last post I have discussed about Vlookup function. My focus is to relate every feature of Excel with our day to day life so it becomes easy to understand the concept behind. Following is the link to blog. Hope it will be useful for you to understand the concept. My next post will be on Hlookup function. If you want to get my post on regular basis than you can share your mail id with me I will send you my post.

https://cfasharmilaprasad.wordpress.com/

I also run online classes on traing of Advance MS Excel. Detail is given on the blog.

Happy Sunday :)

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details