vlookup

	A	B	C	E	G	H	I
1
2	user→	#N/A	66		user→	#N/A	66
3		F	0			F	0
4		E	20			E	20
5		D	40			D	40
6		C	60			C	60
7		B	80			B	80
8		A	100			A	100
9
10
11	user→	0	66
12		100	A
13		80	B
14		60	C
15		40	D
16		20	E
17		0	F
18
19
20	user→	C	66
21		0	F
22		20	E
23		40	D
24		60	C
25		80	B
26		100	A
27
28
29	user→	#REF!	66
30		F	0
31		E	20
32		D	40
33		C	60
34		B	80
35		A	100
36
37				index(b3:b8,match(c2,c3:c8))
38	user→	20	80	index(b3:b8,countif(c3:c8,">"&c2)+1)
39		A	0	感謝soyoso大大
40		B	20
41		C	40
42		D	60
43		E	80
44		F	100
45
46		if(C49<C48, index(C48:C53,countif(C48:C53,">"&C47)+1),index(C48:C53,match(C47,C48:C53)))
47	user→	60	66
48		↑	100
49			80
50			60
51			40
52			20
53			0
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100