Jan 26 2021 03:38 PM
Jan 26 2021 04:19 PM
Jan 26 2021 10:38 PM
@kumop Please see the attached example. You can use LOOKUP or XLOOKUP for this. The latter function will not work if you are not on a recent Excel version. The first will work on all versions.