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

Question

Shozab Abbas · Answer

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

Syed Ilyaz · Answer

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 · Answer

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

Ahmad Ghannam · Answer

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

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

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

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة