Using a name tag in a formula

[mpanty]

Hi.

I was wondering if, instead of using the usual cell code such as A1, B12, L14 etc, if there was a way to use a column heading in a formula instead, and have Excel recognize it. This will probably look more clear with an example.

Say I have the following table, with different player abilities:

Name / Shooting / Tackling / Passing
Marc / 4 / 5 / 10
Jason / 5 / 8 / 9
Jake / 10 / 3 / 6

And I want to use a formula of who's the best defender, forward etc.
So for a forward I would use
=(B2*5+B3*1+B4*3)/5+1+3
(the numbers are just modifiers to give one skill more importance than the others)

My question is: is there a way I can write the same formula, but using for example:
=('shooting'*5+'tackling'*1+'passing'*3)/5+1+3

Can I tell Excel to give one column the parameter "shooting", another column the parameter "tackling" etc. such that when I write 'tackling' in a formula, Excel knows what I'm talking about?

That way, it would be a lot easier for me to re-edit the formula later and pinpoint which skills to give more weight to (think that I have to use many many other skill adjectives).

Any help is appreciated.