Hi
the CERCA function ( LOOKUP) returns the largest value smaller than the lookup value when not found. You should not use it, as it was only created for compatibility reasons.
Instead you can use the CERCA.X function ( XLOOKUP) which should be available in XL2021 AFAIK
5 i am using O365 but cannot change this is my profile as admin decided against it, there being numerous versions of O365)

Attached Files

Function-CERCA-problem.xlsx (12.3 KB, 4 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post