Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Medhat Mohamed sayed Ahmed , HR Manager , Sercotex for Textile
Date Posted: 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
by 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
by 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
by 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
by 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
by Ankita Thapa , Team lead , Concentrix

Vlookup is easy and well known globely

Naresh Khanal
by 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
by Mahmoud Anwar , Salesperson , Pure Health Company

I think that The vlookup is the best to compare 

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

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

Sheryl Montante
by 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.