is it possible to have different dropdown lists appear
depending on value in cell to the left of where you have
your dropdown list. e.g

if A1 = "LP" then b1="Dropdownlist1"
if A1 = MP then b1="Dropdownlist2"

etc etc

Hope you can help

Pete