|We could use some more information.|
For a short list a simple IF function would work:
You could make that function about as long as you like, but after a while it's gets a bit cumbersome.
A better option for a long list would be to use VLOOKUP:
where C2:C100 contains all of the items in your drop down list and D2:D100 contains the associated return value.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.