Forum Discussion
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), yet I am just getting the largest value from the data sheet, 1246000. I have used the following formula:
=INDEX(UKB!R11:R117,MATCH(TRUE,UKB!R11:R117>='Beam Calculations'!I10,0))
Thank you in advanced,
Millie
1 Reply
=INDEX(UKB!R11:R117, XMATCH('Beam Calculations'!I10, UKB!R11:R117, 1))
or
=XLOOKUP('Beam Calculations'!I10, UKB!R11:R117, UKB!R11:R117, "", 1)
