Xlookup Bug?

%3CLINGO-SUB%20id%3D%22lingo-sub-1865417%22%20slang%3D%22en-US%22%3EXlookup%20Bug%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865417%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20--%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20an%20XLookup%20bug%3F%20Seems%20weird%20it's%20return%20a%20%23N%2FA%20error%20for%20some%20values%20not%20others.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1865417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1865453%22%20slang%3D%22en-US%22%3ERe%3A%20Xlookup%20Bug%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1865453%22%20slang%3D%22en-US%22%3EWhat's%20weird%20is%20if%20you%20change%20the%20XLOOKUP%20formula%20to%20this%20%3DXLOOKUP(ROUNDDOWN(F2*100%2C0)%2CA%3AA%2CB%3AB)%3CBR%20%2F%3Eit%20works%2C%20but%20without%20the%20rounddown%20it%20does%20not.%20Weird.%3C%2FLINGO-BODY%3E
New 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.