The RECHERCHEX (XLOOKUP) function looks up a value in a range and returns the matching result from another range. It replaces RECHERCHEV (VLOOKUP): it looks in every direction, does an exact match by default and offers an argument for when the value cannot be found. It can also return several columns.
Example
=RECHERCHEX(A2;Produits[Code];Produits[Prix];"Not found")