Find closest match, excluding current row

[zakakatz]

I've been browsing the forum, and found several relevant examples but can't quite adapt them for my fairly simple need. I am looking to set up a formula in column C, to return the closest matching store (column A) of previous 3 months sales (column B). For example, Store 1 (A2) closest match would be store 13 (A14) based on store 13's sales (99.76) being closest to store 1's 130.94. The one caveat I'm running into, is that with all of the formula's I've tried, it always returns the value from the originating row (ie. my formula's return A2). I know I need to throw in a IF condition with <> A2, however doing so breaks the rest of my formula. Can anyone help?

Store#	Prev 3 Month Sales	Closest Match
1	130.94
2	41.52
3	94.65
4	58.17
5	63.12
6	97.92
7	31.34
8	55.44
9	66.54
10	72.74
11	58.05
12	85.6
13	99.76
14	73.87
15	80.5
16	55.38
17	42.41
18	51.48
19	70.41
20	65.72

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[lrobbo314]

This seems to work. It is an array formula so hit ctrl+shift+enter after pasting it in.

=INDEX($A$2:$A$21,MATCH(MIN(IF($B$2:$B$21<>B2,ABS(B2-$B$2:$B$21))),ABS(B2-$B$2:$B$21),0))