Attaching a 2 item list to a cell / drop-down?

Hi, they say a pic is worth a 1000 works. pls take a look

http://photos1.blogger.com/blogger/1...or%20rates.jpg

I want my users to see how the cost of an audio conference depending of different varialbles (# of phones lines, etc). In the picture I want them to choose the country, which - somehow - populates the rate in the next cell "rate per minute" and then I can do the rest of the calculations.

But the main thing is simply connecting a list to a drop-down cell??... etc

TIA

EM

Use Data Validation, menu Data>Validation, and then select List from the
Allow list and use a formula of =G5:G10 or wherever the list is.

Use VLOOKUP or INDEX/MATCH from the DV cell into the rates table

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Enrique Mahecha"
<Enrique.Mahecha.20esba_1135200000.561@excelforum-nospam.com> wrote in
message news:Enrique.Mahecha.20esba_1135200000.561@excelforum-nospam.com...
>
> Hi, they say a pic is worth a 1000 works. pls take a look
>
>
http://photos1.blogger.com/blogger/1...or%20rates.jpg
>
> I want my users to see how the cost of an audio conference depending of
> different varialbles (# of phones lines, etc). In the picture I want
> them to choose the country, which - somehow - populates the rate in the
> next cell "rate per minute" and then I can do the rest of the
> calculations.
>
> But the main thing is simply connecting a list to a drop-down cell??...
> etc
>
> TIA
>
> EM
>
>
> --
> Enrique Mahecha
> ------------------------------------------------------------------------
> Enrique Mahecha's Profile:
http://www.excelforum.com/member.php...o&userid=10276
> View this thread: http://www.excelforum.com/showthread...hreadid=495341
>

Thanks Bob for your reply!

Just curious, you were not able to see the picture, did you?


Do you have any idea what is the way of showing pictures here?


Thanks

Enrique

Probably a Data Validation drop-down and a VLOOKUP formula to return the rate.

See Debra Dalgleish's site for working with a DV dropdown list and VLOOKUP
formulas.

http://www.contextures.on.ca/xlOrderForm01.html


Gord Dibben Excel MVP

On Wed, 21 Dec 2005 15:17:38 -0600, Enrique Mahecha
<Enrique.Mahecha.20esba_1135200000.561@excelforum-nospam.com> wrote:

>
>Hi, they say a pic is worth a 1000 works. pls take a look
>
>http://photos1.blogger.com/blogger/1...or%20rates.jpg
>
>I want my users to see how the cost of an audio conference depending of
>different varialbles (# of phones lines, etc). In the picture I want
>them to choose the country, which - somehow - populates the rate in the
>next cell "rate per minute" and then I can do the rest of the
>calculations.
>
>But the main thing is simply connecting a list to a drop-down cell??...
>etc
>
>TIA
>
>EM

Yes I saw the picture.

As for me, a link to a file is fine, you can ignore if you wish.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Enrique Mahecha"
<Enrique.Mahecha.20etgy_1135201501.3396@excelforum-nospam.com> wrote in
message news:Enrique.Mahecha.20etgy_1135201501.3396@excelforum-nospam.com...
>
> Thanks Bob for your reply!
>
> Just curious, you were not able to see the picture, did you?
>
>
> Do you have any idea what is the way of showing pictures here?
>
>
> Thanks
>
>
> --
> Enrique Mahecha
> ------------------------------------------------------------------------
> Enrique Mahecha's Profile:
http://www.excelforum.com/member.php...o&userid=10276
> View this thread: http://www.excelforum.com/showthread...hreadid=495341
>

Bob, thanks for info. I wll send link to file next time. In fact I will test a file right now.

"Attention please... this is test.." -- http://www.streamload.com/em22153/Ex..._Questions.xls

Gord, Thanks as well for information. The website you linked looks GREAT! Thanks.

I will be in touch as I need to learn losts of excel in the next few months so I will probably need help again.


bye for now



Thanks
Enrique

Enrique,

As far as I could see, I could only open that file directly, I couldn't
download it. If anyone is going to look at a Excel file (and many won't
regardless), they will want to download the file, and virus check it before
opening. I suggest you look for a free file hosting site, one that allows
you to upload files for a prescribed period, after which they are
automatically deleted.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Enrique Mahecha"
<Enrique.Mahecha.20faty_1135224001.2599@excelforum-nospam.com> wrote in
message news:Enrique.Mahecha.20faty_1135224001.2599@excelforum-nospam.com...
>
> Bob, thanks for info. I wll send link to file next time. In fact I will
> test a file right now.
>
> "Attention please... this is test.." --
> http://www.streamload.com/em22153/Ex..._Questions.xls
>
> Gord, Thanks as well for information. The website you linked looks
> GREAT! Thanks.
>
> I will be in touch as I need to learn losts of excel in the next few
> months so I will probably need help again.
>
>
> bye for now
>
>
>
> Thanks
> Enrique
>
>
> --
> Enrique Mahecha
> ------------------------------------------------------------------------
> Enrique Mahecha's Profile:
http://www.excelforum.com/member.php...o&userid=10276
> View this thread: http://www.excelforum.com/showthread...hreadid=495341
>

Hi Bob, again thanks for your helpful response.


Well, I just opened an account in streamload.com (recommended in a tv show "callforhelptv.com"), which supposes to be the state of the art in file storage, streaming video, etc at reasonable prices. They have many choices to download stuff, etc. I probably used the one I use for sending streaming video where it opens the player and starts showing the video... it did the same with the file

another method is to use a link to a "host" folder, where the viewer can either download the file or open the file (good for video). So, please let me try the other method with you, maybe I can nail it down right away.

I tested this link and it should open a dialog-box with 2 choices "do you want to Open or Save this file," Please test it and let me know if it works... it would be very helpful

http://www.streamload.com/em22153/EL..._Questions.xls


see ya

Enrique
Enrique

Hi Enrique,

Yeah that works fine. I was able to download the file, and save it. I then
virus checked it in safety.

When you say reasonable prices, if that means $$, I use www.cjoint.com. As I
suggested earlier, it is time-boxed, but it is free.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Enrique Mahecha"
<Enrique.Mahecha.20g55m_1135263300.9945@excelforum-nospam.com> wrote in
message news:Enrique.Mahecha.20g55m_1135263300.9945@excelforum-nospam.com...
>
> Hi Bob, again thanks for your helpful response.
>
>
> Well, I just opened an account in streamload.com (recommended in a tv
> show "callforhelptv.com"), which supposes to be the state of the art in
> file storage, streaming video, etc at reasonable prices. They have many
> choices to download stuff, etc. I probably used the one I use for
> sending streaming video where it opens the player and starts showing
> the video... it did the same with the file
>
> another method is to use a link to a "host" folder, where the viewer
> can either download the file or open the file (good for video). So,
> please let me try the other method with you, maybe I can nail it down
> right away.
>
> I tested this link and it should open a dialog-box with 2 choices "do
> you want to Open or Save this file," Please test it and let me know if
> it works... it would be very helpful
>
>
http://www.streamload.com/em22153/EL..._Questions.xls
>
>
> see ya
>
> Enrique
> Enrique
>
>
> --
> Enrique Mahecha
> ------------------------------------------------------------------------
> Enrique Mahecha's Profile:
http://www.excelforum.com/member.php...o&userid=10276
> View this thread: http://www.excelforum.com/showthread...hreadid=495341
>