combo box with more then one link

[Guest]

Hi

I know i ask similer question before but this one bit more complex!

Ok let me make it as simple as i can, i have in sheet1 three column A,B,C,
in (column A) names, in (Column B) Fone No, and in ( column C) Email.

In sheet2 there is Combo box but this combo box is from CONTROL TOOL BOX NOT
FROM FORMS!! so let say i select name from thjat combo box then below it it
iwll show fone no and below that email of that person i selected.

Note: i know how to view fone No but i do not know how to view the email at
the same time.

Please help me guys and thank u very much and i will be looking forward to
hear from u soon

 

[Dave Peterson]

I would use a linked cell hidden under the combobox from the Control toolbox
toolbar to return the name.

Then use that value to show the phone number:

Say you're using A1:A3 of sheet2.

In A2:
=if(a1="","",vlookup(a1,sheet1!a:c,2,false))

In A3:
=if(a1="","",vlookup(a1,sheet1!a:c,3,false))

This will work ok if the names are unique--no duplicate names!

 

[Guest]

cant the control combo display two fields?

 

[Dave Peterson]

In the dropdown area, yep.

In the combobox itself, no.

In the linked cell, no.

Well, I've never seen a way.

But you could use some code to control as many cells as you want.