PROCX - Learn the New Function - Will it replace PROCV?
In this video, you will learn how to use the new XLOOKUP function, which replaces VLOOKUP.
The XLOOKUP function is only available in the Office 365 version and in the free online Excel (Excel for Web).
Free Online Excel: • Como Usar o EXCEL ONLINE GRATUITO
VLOOKUP: • PROCV - Como usar a função PROCV no Excel ...
INDEX and MATCH: • Como Usar ÍNDICE e CORRESP para Substituir...
IFERROR: • Função SEERRO para tratar #N/D no PROCV - ...
We can use the XLOOKUP function to replace the VLOOKUP and INDEX + MATCH functions. The XLOOKUP function also eliminates the need to use the IFERROR function because it has its own argument that fulfills this role.
Find more Excel tutorials on our website:
https://excelderespeito.com.br/
Follow us on Instagram:
/ excelderespeito
Presented by: Diego Silva
On this page of the site you can watch the video online PROCX - Learn the New Function - Will it replace PROCV? with a duration of hours minute second in good quality, which was uploaded by the user Excel de Respeito 17 August 2021, share the link with friends and acquaintances, this video has already been watched 1,703 times on youtube and it was liked by 47 viewers. Enjoy your viewing!
