I hope I can put this understandably.

I have 2 columns (A and B) on one worksheet and 2 columns (a2 and b2) and a
second worksheet.

In Column a2 is a range of values (alpha,beta,charlie...zulu) named "list"
In Column b2 is a range of associated costs (1,2,3,4....26)

Column A has a data valadation field using a drop-down list that allows the
user to choose a name (alpha,beta...)

What I need is for Column B to automaticly fill with the associated cost
depending on whichever value is chosen in Coumn A (so if alpha is chose the
adjacent cell is filled with 1, beta..2, charlie..3)

I can not figure out how to do this. The closest I can come is a very ugly
nested IF statement but even that doesn't work as I can't nest 26 IF
statments. Any help would be wonderfull.