Assign a numerical value to a text string in a list

[hikeleader]

I am creating a scoring worksheet. The user selects one of 5 text statements in a list. I assign a numerical 'score" to each one. I want that score to be "returned based on the text selection so that I can incorporate into a formula. How do i go about doing that? Do I use "lookup" ? "If" or what????

Thanks for any help!

 

[Aladin Akyurek]

=VLOOKUP(DropdownSelection,Table,2,0)

where Table is a 2-column range that associates text values and numbers.

 

[hikeleader]

That works well....
I took that and added 5 vlookups to create a single score.....

=(VLOOKUP(B11,B87:C91,2,0))+(VLOOKUP(C11,B93:C97,2,0))+(VLOOKUP(D11,B99:C103,2,0))+(VLOOKUP(E11,B105:C109,2,0))+(VLOOKUP(F11,B112:C116,2,0))

now..
how can I "easily" copy that formula down a column?

If I just "copy" I get invalid references....I need the table to be constant...)

 

[Aladin Akyurek]

That works well....
I took that and added 5 vlookups to create a single score.....

=(VLOOKUP(B11,B87:C91,2,0))+(VLOOKUP(C11,B93:C97,2,0))+(VLOOKUP(D11,B99:C103,2,0))+(VLOOKUP(E11,B105:C109,2,0))+(VLOOKUP(F11,B112:C116,2,0))

now..
how can I "easily" copy that formula down a column?

If I just "copy" I get invalid references....I need the table to be constant...)

Would using $B$87:$C$116 as the lookup table for B11, C11, D11, E11, and F11 cause any trouble?