Multiple Drop Down List to Equal Numbers

[mbe23]

I am having difficulties in creating the best formula for my needs and I would be grateful if someone could help me.

I have 2 drop down lists which I would like to use together to create an overall points.

For example:

Drop Down List 1:

Table=100
Chairs=25
Desk=50
Coffee Table=30

Drop Down List 2:

Lined Paper=15
Plain Paper=15
Notepad=20
Pens=10
Pencils=5
Colouring Pencils=15
Colouring Pens=10
Ruler=10

So if for example a chair and a notepad was selected it would equal 45 points.

Thanks

[NBVC]

You would have to clear the data validation rules from F2 down and then insert formula in F2:

=VLOOKUP(B2,$L$3:$M$10,2,0)+VLOOKUP(D2,$N$3:$O$10,2,0)

copied down.

[6StringJazzer]

See attached. Please look up "VLOOKUP" and "Named Ranges" in Help to see how this works.