There appears to be an error in excel formula when combining Xlookup with Make array formula:

e.g.

You can see randomly #N/A errors appear.

Its almost as if the XLOOKUP isn’t anticipating the lookup value to be multiplied because if I specify exact it works fine.

Data to mimic:

A   B
0.19    Test
0.38    2.33195E-15
0.57    5.3411E-15
4.00    7.49672E-15
5.00    8.93319E-15
6.00    9.85973E-15

Array formula:

=MAKEARRAY(5,6,LAMBDA(x,y,XLOOKUP((y*0.19), Table1[A],Table1[B])))