Excel 2007 : Help in writing formula to return value closest to a specified value for a horizontal arry

Hi,

I have tried to use the following formula to return a value from a horizontal array closest to a specified value:

=INDEX(CMTable,MATCH(MIN(ABS(CMTable-E111)),ABS(CMTable-E111),0),1)

However, this function only works for certain horizontal array. Any way to ensure that this works for any horizontal array?

Thanks so much!