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

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

Hi,

I wonder why you need a combo box for it. If you type 6 in a cell, you can
use INDEX() and MATCH() in another cell to get June as the answer.
therefore, if you type, 6 in cell A14, in cell B14, you can use

=index(A1:B12,match(A14,B1:B12,0),1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Amnon Wilensky" wrote in message
...
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