I think you are talking about a conditional dropdown? Try this:
http://www.contextures.com/xlDataVal02.html
************
Anne Troy
www.OfficeArticles.com

"KimStarbase" wrote in message
...
What I am trying to achieve is a drop down list that would look something
like this:

D1a - suipplies
F1g - cell phones
C2a - travel
E4b - computers

and so on and so forth. I can do that.
What I would like to happen though is in the same cell that the drop down
box is in (a29) I would like to select one of those options and only have
D1a, or F1f, ect show up in the cell. The words are just references to my
budget, and I don't nned them after I selected the right one. Is this
possible?
I am somewhat new to excel and have never went into the visual basic
editor
and I don't have clue on how to use it.
Thanks for all your help