software

Please Help!!

I have column A as a drop down list and would like it if column C would
give a corresponding price to what is picked in column A from the drop
down list.
Any quick fixes?

Thanks A Bunch!--
kgeorge
------------------------------------------------------------------------
kgeorge's Profile: www.excelforum.com/member.php...oamp;userid=32804
View this thread: www.excelforum.com/showthread...hreadid=532065
You make a table somewhere within your workbook (possibly expand on the
source list for your drop down?) with your data that comprises your
drop down list and in the adjacent column list the prices that are
associated to each item in your list.
Then use a VLOOKUP() formula in column C of the sheet containing your
drop down. When an item is selected from your drop down the formula
will display the associated price from your table.

Something like:

=VLOOKUP(cell holding the drop down,sheet name amp; range of your
table,2,0)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=532065Do you have a table of items amp; corresponding prices?

Let's say that range G1:G10 contains the labels for your drop down. In
H1:H10 put the prices

in C1 use:

=vlookup(A1,$G$1:$h$10,2,false)

quot;kgeorgequot; wrote:

gt;
gt; Please Help!!
gt;
gt; I have column A as a drop down list and would like it if column C would
gt; give a corresponding price to what is picked in column A from the drop
gt; down list.
gt; Any quick fixes?
gt;
gt; Thanks A Bunch!
gt;
gt;
gt; --
gt; kgeorge
gt; ------------------------------------------------------------------------
gt; kgeorge's Profile: www.excelforum.com/member.php...oamp;userid=32804
gt; View this thread: www.excelforum.com/showthread...hreadid=532065
gt;
gt;