Matching formula results to datasets
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
|