Combo Box problem

[zaska]

Hi all,

I have the Formula " =Index (A6:A17,$F$1) " In Cell A2

and a Combo Box with input Range " (A6:A17) " and F1 as the Cell Link.

My problem is the Combo Box is not showing the values in Input Range i.e JAN,FEB,MAR,APR Etc.,

Instead it is showing the number of the Months...1,2,3,4 i.e the values Cell F1


How do i make the Combo Box show the Values " JAN , FEB , MAR " Instead of 1,2,3,4 etc..

I am using this combobox to display chart ....for the months of JAN, FEB etc.,

Kindly suggest the solution

 

[zaska]

Thank you sir,

My problem got solved.

I tried the vLookup Table