XLOOKUP gives wrong value

Hi,

I am new to the portal. I use Office 365 quite effectively, but I am not able to solve the following problem.

I need to look up for a specific reference in a list of values and return an exact match.
The lookup array is a combination of text values and numerical values (154350 / OVEA350155 / MTKEDA).
The first 4 letters of my lookup value are always the same (OVEA), the rest of the values are different.

Some of the OVEA references have 8 digits and some 6.

The problem arise when I am searching for an OVEA reference with 6 digits and only when there is another OVEA reference with 8 digits out of which the first 6 identical to the digits inside the lookup value. (154350 / OVEA350155 / MTKEDA and 154350 / OVEA35015512 / MTKEDA).

Using XLOOKUP("*"&LookupValue&"*",LookupArray,ReturnArray,"",2) gives wrong result when the first value in the list is the longer one.

Please check the attached file for your reference.

I will appreciate if you can help me out getting the correct result.

Thank you.