Combo box interagation

[Phil J]

I have created a combo box in sheet using the control toolbox function and defined the list of surnames. I want to be able to create an "if" statement that looks at the entry selected in the combo box and gives the corresponding address. I have allocated a name to the combo box and used that name in an "if" statement but only get a false result. Any assitance appreciated.

 

[Aladin Akyurek]

On 2002-05-12 18:07, Phil J wrote:
I have created a combo box in sheet using the control toolbox function and defined the list of surnames. I want to be able to create an "if" statement that looks at the entry selected in the combo box and gives the corresponding address. I have allocated a name to the combo box and used that name in an "if" statement but only get a false result. Any assitance appreciated.

=VLOOKUP(E8,Addresses,2,0)

where E8 is the LinkedCell and List is the value for ListFillRange.

In your case List would be the list of surnames.

Hope this helps.
This message was edited by Aladin Akyurek on 2002-05-12 19:19
This message was edited by Aladin Akyurek on 2002-05-12 19:24

 

[Yogi Anand]

Hi Aladin:
Wouldn't the linked cell give the index number (i.e the row number of the selected list item -- in that case

=index(Namerange,LinkedCell,2) will give surname if the surname is in column 2 of the NameRange

Regards!
This message was edited by Yogi Anand on 2002-05-12 20:24

 

[Aladin Akyurek]

On 2002-05-12 20:22, Yogi Anand wrote:
Hi Aladin:
Wouldn't the linked cell give the index number (i.e the row number of the selected list item -- in that case

=index(Namerange,LinkedCell,2) will give surname if the surname is in column 2 of the NameRange

Regards!
This message was edited by Yogi Anand on 2002-05-12 20:24

I believe the combobox is created with View|Toolbars|Control ToolBox, not Forms.

In the latter case:

=VLOOKUP(INDEX(Input-range,Cell-link),Addresses,2,0)

would be more appropriate.

 

[Yogi Anand]

I reviewed the file emailed to me by PhilJ ...

if the ComboBox is made with View|Toolbars|ControlToolBox -- then linked cell selects the actual item from the list, and the correct formula to use is:

=VLOOKUP(LinkedCell,List,2,0)

if the ComboBox is made with View|Toolbars|Forms -- then the linked cell selects the index_number of the item, and the correct formula to use is:

=INDEX(List,index_number,2)