Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
data is in descending order. As per our use case, it is set to -1 After putting all these parameters in the XLOOKUP function, it appears as follows: =XLOOKUP(K8,B4:B13, D4:E13,”Record Not Found”,0,-1) The following DsExcel code shows how to retrieve the salesperson and the region name using the