Forum Discussion
Look up a value to assign a label
Is there a function I can use to look up a value and assign a label if it's less then another value; for example, I have a list of numbers, with an assigned label and a number I want to search. V...
bma1412 If you have a recent version of Excel (2021 or later, I believe), this can be accomplished with the XLOOKUP function, specifying a match_mode argument of 1. For details and alternative solutions, see the attached workbook.