XLookup returning wrong values when using two conditions

Hi,

with this beeing my first post, be gentle with me I did not find this anywhere, so hopefully its a new problem to you.

When using the new xlookup with two conditions and match_mode =1 (exact match or next larger) (did not test with other match modes) the formula will sometimes return wrong values.

Please take a look at the attached file and tell me what I'm doing wrong :/
First I created a xlookup with only one condition, the results are correct.
Next I created a xlookup with two conditions and marked the wrong results.

Thank you. Worked perfectly.

I dont understand the problem though. Why are the cells read as text when they are formatted as numbers? I would have guessed the problem myself if I would have known :p