Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
Date de publication: 2016/03/09

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
par 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
par 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
par 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
par 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
par Ankita Thapa , Team lead , Concentrix

Vlookup is easy and well known globely

Naresh Khanal
par 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.

Utilisateur supprimé
par Utilisateur supprimé

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
par Mahmoud Anwar , Salesperson , Pure Health Company

I think that The vlookup is the best to compare 

Davinder Singh Davinder Singh
par Davinder Singh Davinder Singh , Deputy Section Officer , Dayanand Medical College & Hospital, Ludhiana

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

Sheryl Montante
par 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.

More Questions Like This