combo box with more then one link
 

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

combo box with more then one link
 

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!

Hassan Merzha wrote:

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

combo box with more then one link
 

cant the control combo display two fields?
--
paul

remove nospam for email addy!



"Dave Peterson" wrote:

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!

Hassan Merzha wrote:

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

combo box with more then one link
 

Hi Dava

I have Tired it but it does not work. it keep showing FALSE.

"Dave Peterson" wrote:

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!

Hassan Merzha wrote:

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

combo box with more then one link
 

Try entering the formula once more.

If it doesn't work, paste your formula in your next replay.

Hassan Merzha wrote:

Hi Dava

I have Tired it but it does not work. it keep showing FALSE.

"Dave Peterson" wrote:

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!

Hassan Merzha wrote:

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


--

Dave Peterson

combo box with more then one link
 

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.

paul wrote:

cant the control combo display two fields?
--
paul

remove nospam for email addy!

"Dave Peterson" wrote:

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!

Hassan Merzha wrote:

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


--

Dave Peterson