Ooh .. Linking a list to a list to an output cell

[Guest]

I have a single cell in which i enter the price of a home. Elsewhere, I have
two columns of ten items each: one column is formulated to give relative
prices based on the price entered in the single cell, and the column adjacent
to this column describes these numbers in nominal terms (i.e. ten items in
increments of five percent: "25% more" .. " 0% change" .. "25% less").

Further along, I have a list box created which uses the nominal column at
the Source for the list. I would like to have a cell adjacent to the list
box cell which will give the price based on the selection in the list box.
How do I link these three objects (the list box, the real price column, and
the output cell)?

Thanks in advance..

 

[Excel_Geek]

I've attached an example file for what I think you're trying to
accomplish.

Let me know if it helps.


+-------------------------------------------------------------------+
|Filename: For_StrawDog.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3714 |
+-------------------------------------------------------------------+

 

[Guest]

Can't view attachment!

 

[Excel_Geek]

Use this link to get to the attachment.

This forum's got a little problem with the links they put in the emails
and even on the forum pages. (They end the query string
"...?postid=XXXX" instead of "...?attachmentid=XXXX")

http://www.excelforum.com/attachment.php?attachmentid=3714"

 

[Guest]

Awesome! Thanks