Vlookup, hlookup

Excel 647 views 2 replies

Bhavesh

Accounts

899 Points Joined May 2010

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)

Mehul Thakkar

CA CISA DISA CEH MOS Excel Expert

194 Points Joined May 2008

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

Sharmila Sharma

CFA

49 Points Joined August 2014

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 :)