In Excel? Why not let the guys in Excel answer this?
You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using. I would suggest you include your Windows and Office version
number in the message.
If you have a question about Excel, I'd suggest reposting it in an Excel
newsgroup. If the question is about Microsoft Access (the subject of this
newsgroup) please expand your question; you can certainly create a Form based
on your table and put Combo Boxes on the form to do what you ask.