Most likely, the second argument (lookup_array) points to multiple columns, but XLOOKUP only searches the first one. Fix it: specify a single column, e.g., =XLOOKUP(A2; C2:C100; D2:D100).

Also fill the fourth argument [if_not_found] with an empty string to avoid #N/A errors. For unsorted data, remove or set 1 in the [search_mode] argument — binary search (2 or -2) is not suitable here. Remove invisible spaces before numbers using the TRIM function.

Before searching, it is convenient to clean the data — follow the instructions for comparing two columns in Excel.

🔗 Source: excel.rf