VLOOKUP or INDEX+MATCH?

[amalCSCC]

Hello all,
I have been trying to look for the right formula between VLOOKUP and INDEX+MATCH; When should I use each function?
Can you please help?
Thanks,

 

[DanteAmor]

Hi and welcome to MrExcel

With version 365, the best option is XLOOKUP

XLOOKUP function - Microsoft Support

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...

support.microsoft.com

 

[amalCSCC]

Hi and welcome to MrExcel

With version 365, the best option is XLOOKUP

XLOOKUP function - Microsoft Support

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...

support.microsoft.com

Thank you for your answer!