Index and match values closest to zero and return the value on the left column

[mcva]

Hi,
I need to get the number included on the Segment column that corresponds to the value of the column Value that is closest to zero.

I have tried this:
=INDEX($A$2:$A$12,MATCH(MIN(ABS(IF(ISNUMBER(D2:D12),D2:D12,9999))),D2:D12, FALSE),1)

, however, I´m getting #N/A when the values in the column Value are negative.

I have included the file in the following link.

test.xlsx

Shared with Dropbox

www.dropbox.com

Thank you

 

[Phuoc]

Try this

Book1
	A	B	C	D	E	F	G	H	I
1	ment	Variable	Value			Result (obtained)		Result (correct)
2	3	Age	7.5703		Age	12		12
3	4	Age	5.0985		Algae	13		13
4	5	Age	5.5075
5	6	Age	8.1797
6	7	Age	5.7631
7	8	Age	4.172
8	9	Age	2.773
9	10	Age	1.9327
10	11	Age	0.6872
11	12	Age	0.0672
12	13	Age	-1.3081
13	3	Algae	-6.8438
14	4	Algae	-4.9515
15	5	Algae	-7.0199
16	6	Algae	-9.7278
17	7	Algae	-8.6744
18	8	Algae	-8.915
19	9	Algae	-8.0765
20	10	Algae	-6.9841
21	11	Algae	-6.1208
22	12	Algae	-4.8454
23			C22
24	13	Algae	-3.5196
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=INDEX($A$2:$A$24,MATCH(AGGREGATE(15,6,ABS($C$2:$C$24)/($B$2:$B$24=E2),1),ABS($C$2:$C$24)/($B$2:$B$24=E2),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[mcva]

Try this

Book1
	A	B	C	D	E	F	G	H	I
1	ment	Variable	Value			Result (obtained)		Result (correct)
2	3	Age	7.5703		Age	12		12
3	4	Age	5.0985		Algae	13		13
4	5	Age	5.5075
5	6	Age	8.1797
6	7	Age	5.7631
7	8	Age	4.172
8	9	Age	2.773
9	10	Age	1.9327
10	11	Age	0.6872
11	12	Age	0.0672
12	13	Age	-1.3081
13	3	Algae	-6.8438
14	4	Algae	-4.9515
15	5	Algae	-7.0199
16	6	Algae	-9.7278
17	7	Algae	-8.6744
18	8	Algae	-8.915
19	9	Algae	-8.0765
20	10	Algae	-6.9841
21	11	Algae	-6.1208
22	12	Algae	-4.8454
23			C22
24	13	Algae	-3.5196
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=INDEX($A$2:$A$24,MATCH(AGGREGATE(15,6,ABS($C$2:$C$24)/($B$2:$B$24=E2),1),ABS($C$2:$C$24)/($B$2:$B$24=E2),0))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thank you very much, much better