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

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

In compare of two functions, which is faster and useful? The Vlookup() Function Or The Index() Function ?

user-image
تم إضافة السؤال من قبل Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
تاريخ النشر: 2016/03/09
mostafa ahmed
من قبل mostafa ahmed

index function best Because Function Vlookup working from right to left in Arabic and vice foreign language     The index and function match function in both directions together Vtaml

 

Medhat Mohamed sayed Ahmed
من قبل Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile

The Easier Formula To Use Is vlookup()

But Based on the Efficiency index() formula is the winner as it's works in both direction as mentioned and i read  a study some where that  it's faster than vlookup()

TAMER ELSAYED ABDOU HASAN KHALIL ELKAREISH ELKAREISH
من قبل TAMER ELSAYED ABDOU HASAN KHALIL ELKAREISH ELKAREISH , مراجع حسابات , جامعة الزقازيق

index function bestBecauseFunction Vlookup working from right to left in Arabic and vice foreign language

VIJAYARAGHAVAN S VIJAY
من قبل VIJAYARAGHAVAN S VIJAY , Assistant Manager , Muthoottu Mini Financiers Ltd

Excel offers two primary lookup methods: VLOOKUP and INDEX-MATCH. Although the two methods are similar, INDEX-MATCH is more powerful

Chandrakanth Chandrasekhar
من قبل Chandrakanth Chandrasekhar , Mechanical supervisor , Crown industries

Index function, because its simple as = index:(select all tables, no of rows, no of columns),

try this. 

Ankita Thapa
من قبل Ankita Thapa , Team lead , Concentrix

Vlookup is easy and well known globely

Naresh Khanal
من قبل Naresh Khanal , Tax Consultant , Deloitte

There are two aspects connected to this question and depends on what output we need. If the data is small then VLOOKUP is very much faster as it is easy to use even for a beginner.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

I prefer to use combination of Index & Match over vlookup as we can work left & right, moreover it does not hang when working on sheet with more than 50k line items.

But Vlookup is easier to use. 

Mahmoud Anwar
من قبل Mahmoud Anwar , Salesperson , Pure Health Company

I think that The vlookup is the best to compare 

Davinder Singh Davinder Singh
من قبل Davinder Singh Davinder Singh , Deputy Section Officer , Dayanand Medical College & Hospital, Ludhiana

VLOOKUP ( ) formula is most useful and faster function in excel.

Sheryl Montante
من قبل Sheryl Montante , Sales Executive Assistant , Bayan Telecommunications Inc.

i regularly used the VLOOKUP () formula as this is much useful to me in any other reports.

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