Match Index Maybe?

[Silvermini63]

Ok What I am after is a match of List to put our customer base on with their % (column “C”) for the Max % in column “I”. The formula is for column E

For example the first customer would return XX4 because they are above XX5’s max % of 19.99 and below XX4’s max % of 24.99. Customer two would be XX6.

Hope this is clear?

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Area	A/C	%	Cur list	Sug New List		List	Return	Max %
2	XXXX	1	20.80	XX1			XX0	60%
3	XXXX	2	11.60	XX1			XX1	35%
4	XXXX	3	11.40	XX1			XX2	30%	34.99
5	XXXX	4	11.70	XX1			XX3	25%	29.99
6	XXXX	5	11.30	XX1			XX4	20%	24.99
7	XXXX	6	20.00	XX2			XX5	15%	19.99
8	XXXX	7	18.10	XX3			XX6	10%	14.99
9	XXXX	8	9.00	XX4			XX7	8%	9.99
10	XXXX	9	24.60	XX5			XX8	5%	7.99
11	XXXX	10	30.80	XX1			XX9	2%	4.99
12	XXXX	11	19.30	XX1
13	XXXX	12	16.60	XX1
14	XXXX	13	17.60	XX1
15	XXXX	14	18.70	XX1
16	XXXX	15	21.90	XX1
17	XXXX	16	17.10	XX1
18	XXXX	17	18.90	XX1
Sheet2

Excel 2010

 

[Haseeb Avarakkan]

Hello, Try, E2 copy down...

=INDEX($G$2:$G$11,MATCH(C2,$I$2:$I$11,-1))