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
 
Back
Top