Formula Help_Score to Weightage

[KPV_0921]

Hello,

Need help on what formula I can use to be able to automatically populate the corresponding weightage of my team's score. Referencing the table below, need to automatically populate the weightage in column O (G&O Score) based from column M (%) to reference score range in the weightage table beside it. Thanks in advance.

 

[Eric W]

Welcome to the MrExcel forum!

It's easiest if you adjust your Weightage table slightly, to have separate columns for the start and end values. Then you can just use a VLOOKUP like so:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Submissions
2	<10 Day	>10 Day	Total	%	G&O Score			Weightage
3				46%	3%			0.0%	20.0%	6%
4				38%	3%			20.1%	50.0%	3%
5				4%	6%			50.0%	100.0%	0%
6				35%	3%
7				13%	6%
8				2%	6%
9				36%	3%
10				16%	6%
11				67%	0%
12				23%	3%
13				21%	3%
14				15%	6%
15				2%	6%
16				2%	6%
Sheet8

Cell Formulas
Range	Formula
E3:E16	E3	=VLOOKUP(D3,$H$3:$J$5,3)

 

[KPV_0921]

Welcome to the MrExcel forum!

It's easiest if you adjust your Weightage table slightly, to have separate columns for the start and end values. Then you can just use a VLOOKUP like so:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Submissions
2	<10 Day	>10 Day	Total	%	G&O Score			Weightage
3				46%	3%			0.0%	20.0%	6%
4				38%	3%			20.1%	50.0%	3%
5				4%	6%			50.0%	100.0%	0%
6				35%	3%
7				13%	6%
8				2%	6%
9				36%	3%
10				16%	6%
11				67%	0%
12				23%	3%
13				21%	3%
14				15%	6%
15				2%	6%
16				2%	6%
Sheet8

Cell Formulas
Range	Formula
E3:E16	E3	=VLOOKUP(D3,$H$3:$J$5,3)

Thank you very much. It worked!