Xlookup Bug?

Copper Contributor

Hi -- 

 

Is this an XLookup bug? Seems weird it's return a #N/A error for some values not others. 

1 Reply
What's weird is if you change the XLOOKUP formula to this =XLOOKUP(ROUNDDOWN(F2*100,0),A:A,B:B)
it works, but without the rounddown it does not. Weird.