Combo Box

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
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
 
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

Similar Threads

Mapping strings to integers 5
Want to offset found value using Index 2
Need formula help 8
Conditional Formatting with Dates (Revised) 5
variable in data validation 4
Twin cells 5
If Month? 16
countif 3

Back
Top