Hi,
Take a look at Debra web

http://www.contextures.com/xlDataVal10.html

Hope this help

"Amnon Wilensky" wrote:

Hi,
I have to columns of data. The first is with the Months and the other is
with Numbers, For example, in column A1:A12 there are the months (January,
February etc.) and column B1:B12 is filled with numbers starting with 1, 2,
.....
What I want to do is to create a combo box that will show me the month
related to the number. For example: if I will click on the number 6, June
will appear.
Using Excel 2003.
Thanks,
Amnon