Get data from adjacent cells

Last rusty question for the evening.

In Cell F17 I have the following which selects the closest match from a series of 3 cells - which is great - does exactly what I need it to do.

=INDEX(F14:F16,MATCH(MIN(ABS(F14:F16-F7)),ABS(F14:F16-F7),0))

Next, I need the data from the adjacent cell to the left of the closest match to be displayed in cell, lets say F18.

How can I do this? The data in the adjecent cells to the left of F14:F16 is a number.

Thanks, PB.

Originally Posted by p24leclerc

Hi,
you say you want the cell to the left of the closest match. it should be E14 or E15 or E16. Not F18. Or there is something I don't understand.
If you want the cell to the left of the closest match, you just have to change the first range if your Index function to E14:E16.

Hi, sorry, I may have explained badly.

Let me try again:

In cell F20, I want to display the value of that contained in the adjacent cell to the left of the cell that contains the closest match calculated by F19 which is: =INDEX(F14:F16,MATCH(MIN(ABS(F14:F16-F7)),ABS(F14:F16-F7),0))

So, one of the cells E14:E16 has the value that I want, I just don't know how/if I can get it based on the fact that it will be directly to the left of the cell that is the closest match found by the formula in F19.

Thanks, PB.