Combo Box

A

Amnon Wilensky

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
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top