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.

[TABLE="width: 0"]
<colgroup><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="124"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Individual
[/TD]
[TD]Score[/TD]
[TD]Score + NF[/TD]
[TD][/TD]
[TD][/TD]
[TD]Normalizing Factor[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]AM[/TD]
[TD="align: right"]0.00540
[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]KB[/TD]
[TD="align: right"]-0.00221
[/TD]
[/TR]
[TR]
[TD]AM [/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]CT[/TD]
[TD="align: right"]-0.00400[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]GV[/TD]
[TD="align: right"]-0.00185[/TD]
[/TR]
[TR]
[TD]KB[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]BW[/TD]
[TD="align: right"]0.00640[/TD]
[/TR]
[TR]
[TD]KB[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]YZ[/TD]
[TD="align: right"]0.3413[/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GV[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GV[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BW[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]YZ
[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<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]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Individual​

[/td][td="bgcolor:#F3F3F3"]

Score​

[/td][td="bgcolor:#F3F3F3"]

Score + NF​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

Normalizing Factor​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]AM[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

2.00540​

[/td][td="bgcolor:#CCFFCC"]C2: =B2 + VLOOKUP(A2, $E$2:$F$7, 2, FALSE)[/td][td]AM[/td][td]

0.00540​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]AM[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

1.00540​

[/td][td][/td][td]KB[/td][td]

-0.00221​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]AM[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

3.00540​

[/td][td][/td][td]CT[/td][td]

-0.00400​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]AM[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

2.00540​

[/td][td][/td][td]GV[/td][td]

-0.00185​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]KB[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

0.99779​

[/td][td][/td][td]BW[/td][td]

0.00640​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]KB[/td][td]

4​

[/td][td="bgcolor:#CCFFCC"]

3.99779​

[/td][td][/td][td]YZ[/td][td]

0.34130​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]CT[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

0.99600​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]CT[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

1.99600​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]CT[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

0.99600​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]GV[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

1.99815​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]GV[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

2.99815​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]BW[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

1.00640​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]YZ[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

2.34130​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]