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)