On 5 Apr, 15:38, Teethless mama
wrote:
Sort your data in Descending order

=INDEX(A1:A7,MATCH(C2,A1:A7,-1))

Adjust to suit

"Ben Burns" wrote:
Any help/advice much appreciated...

I have a numerical value produced as a result of an existing formula
and need to find the closest higher value from a predefined list.

Does anyone know how to perform this sort of lookup, with the match
from the pre-defined list as the output?

Thanks
Ben

This works perfectly. Many thanks.