ExcelBanter - Better performance Vlookup or Index/Match?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Better performance Vlookup or Index/Match? (https://www.excelbanter.com/excel-worksheet-functions/196897-better-performance-vlookup-index-match.html)

dan

Better performance Vlookup or Index/Match?

What methodology will provide better performance (mainly speed) for returning
a data from a table:
Vlookup or Index/Match?.
Many thank,
Dan

Infinitogool

Better performance Vlookup or Index/Match?

Hi Dan
See the article
http://www.decisionmodels.com/optspeede.htm

Regards,
Pedro J.

What methodology will provide better performance (mainly speed) for returning
a data from a table:
Vlookup or Index/Match?.
Many thank,
Dan

All times are GMT +1. The time now is 01:07 AM.