Defined names...

Not sure if this is the right section to put this in, but here goes...

I have grouped together a few cells (let's say 6) in a column and defined then with a name called "weighting"

each cell contains a level, so the top cell is LVL1, then next one LVL2 and so on down to LVL6

next to these levels names I have some numbers. In a little test sheet, I want select the level in a drop down list, then use the corresponding value to multiply a score and give a result, but I'm not sure how to do this, any help would be much appreciated...

I have attached an example of what I'm trying to do.

much thanks

V.

That's Brilliant Norie, works a treat.

Much thanks

V.