Forum Discussion
milliemai
Apr 06, 2024Copper Contributor
Retrieving the first value in a list that is greater / smaller than a specified value
Hi all I am hoping for some help, I have a datasheet in my excel file, and I would like to retrieve the next value from the datasheet (R11:R117), that is greater than a specified value (I10, 4000...
HansVogelaar
Apr 06, 2024MVP
=INDEX(UKB!R11:R117, XMATCH('Beam Calculations'!I10, UKB!R11:R117, 1))
or
=XLOOKUP('Beam Calculations'!I10, UKB!R11:R117, UKB!R11:R117, "", 1)