Return the tables column for given row and approx. value

Hi,

I have got a formula in C13 which returns the requested col. number - however, I have a feeling that you will probably find a simple and maybe shorter one.

As usually, no VBA nor Helper column, please.

Thanks, Elm

You could avoid the Volatility and shorten slightly by using INDEX

=SUM((ABS(INDEX(C4:G8;G12;0)-G11)=MIN(ABS(INDEX(C4:G8;G12;0)-G11)))*C3:G3)
confirmed with CTRL + SHIFT + ENTER

The above should also work even if the value is lower than 1st value or greater than last value unlike the present version.

How about:

=MATCH(MIN(ABS(INDEX(C4:G8,G12,0)-G11)),ABS(INDEX(C4:G8,G12,0)-G11),0)

confirmed with CSE

Much better - not sure why I didn't think of that - that's 1 oversight each of late I think - your Evaluate to my Array