Hi there,
Does anyone know of a way to combine both the Less than and Equal to functions to MATCH? The 1 in the formula below only matches values that are less than the target value. Is there a way of changing the approximation of the match to include both equals to and less than? For some reason it seems to only accept one input (either less than (1), equals to (0) or greater than (-1) hence why I ask.
=INDEX($F$5:$F$9,MATCH(B2,$E$5:$E$9,1))
Does anyone know of a way to combine both the Less than and Equal to functions to MATCH? The 1 in the formula below only matches values that are less than the target value. Is there a way of changing the approximation of the match to include both equals to and less than? For some reason it seems to only accept one input (either less than (1), equals to (0) or greater than (-1) hence why I ask.
=INDEX($F$5:$F$9,MATCH(B2,$E$5:$E$9,1))