Multi-varible summation

[AdMission]

I realize this is very easy for most on this board, but my expertise is quite limited.

I would like to build a formula to add a unique normalization factor to scores that that individual has given.

Individual	Score	Score + NF			Normalizing Factor
AM	2			AM	0.00540
AM	1			KB	-0.00221
AM	3			CT	-0.00400
AM	2			GV	-0.00185
KB	1			BW	0.00640
KB	4			YZ	0.3413
CT	1
CT	2
CT	1
GV	2
GV	3
BW	1
YZ	2

<colgroup><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="124"></colgroup><tbody>
</tbody>

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[njimack]

=[@Score]+INDEX(Table_Factor[Normalizing Factor],MATCH([@Individual],Table_Factor[Individual],0))

 

[AdMission]

Thank you, Neil. I will try and muddle through this.

 

[AdMission]

=[@Score]+INDEX(Table_Factor[Normalizing Factor],MATCH([@Individual],Table_Factor[Individual],0))

As a newbie, I am having trouble trying to interpret all of the nomenclature you are throwing down with the brackets and @ symbols.

 

[shg]

	A​	B​	C​	D​	E​	F​
1​	Individual​	Score​	Score + NF​	​	​	Normalizing Factor​
2​	AM	2​	2.00540​	C2: =B2 + VLOOKUP(A2, $E$2:$F$7, 2, FALSE)	AM	0.00540​
3​	AM	1​	1.00540​		KB	-0.00221​
4​	AM	3​	3.00540​		CT	-0.00400​
5​	AM	2​	2.00540​		GV	-0.00185​
6​	KB	1​	0.99779​		BW	0.00640​
7​	KB	4​	3.99779​		YZ	0.34130​
8​	CT	1​	0.99600​
9​	CT	2​	1.99600​
10​	CT	1​	0.99600​
11​	GV	2​	1.99815​
12​	GV	3​	2.99815​
13​	BW	1​	1.00640​
14​	YZ	2​	2.34130​