Este artículo no está disponible en su idioma.

Speedy lookups

Monitor showing a worksheet with a speedometer in the lower right corner

Have you ever used VLOOKUP, HLOOKUP, or MATCH to find an exact match in unsorted data? If so, you might have noticed that it took a little while. However, in this update of Excel, you'll notice these calculations are noticeably faster.

For example, in a previous version of Excel, we found five VLOOKUP formulas that took 37 seconds to calculate. But in this update, the same calculation took only take 12 seconds. That's approximately a 67% reduction in calculation time!

There are other performance improvements in this update as well. Read more about these improvements here.

Ampliar sus conocimientos de Office
Explorar los cursos
Obtener nuevas características primero
Únase a los participantes de Office Insider

¿Le ha sido útil esta información?

¡Gracias por sus comentarios!

Gracias por sus comentarios. Quizá le interese ponerse en contacto con uno de nuestros agentes de soporte de Office.