Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Describe the limitation of VLOOKUP or HLOOKUP function in Excel? What would you use instead and why?

user-image
Question added by Ivan Perak , Business / Financial Analyst , Hypo Alpe Adria Bank
Date Posted: 2013/07/07
Shozab Abbas
by Shozab Abbas , Internal Auditor , RAFAQIBS ENTERPRISES

To lookup required data vertically and horizontally. Mostly  used in Audit 

Syed Ilyaz
by Syed Ilyaz , BI Manager , Syren Technology

There is no limitation of using those two functions but it is time consuming for large datasets. Instead of this two functions we can use index and match functions to extract in both format horizontal and vertical.

Ivan Perak
by Ivan Perak , Business / Financial Analyst , Hypo Alpe Adria Bank

And what if the value you are looking for is at the left of the field you are joining by?

Ahmad Ghannam
by Ahmad Ghannam , Zone Manager , Nokia

V and Hlookup is important functions in Excel used when you have tracker sheet and someone ask you to check or fill some information from your tracker you can used vertical or horizantal lookup that depends in your tracker cells to give the informtion in very short time and100% accurate

More Questions Like This