How can I give text a changeable numeric value?
Steve
I think you would need a VLOOKUP formula in the cell adjacent to you DV dropdown
cell that would return the price.
=VLOOKUP(A1,Sheet2!$A$1:$C$4,3,FALSE)
Also on sheet 2 you would need a third column that concatenates the speaker
types and prices.
On Sheet2 insert a column left of column A and enter in A1
=B1&" ($"&C1&")" drag/copy down then copy and paste specialvalues
Now define A1:A4 with a range name like myname.
On sheet1 in your A1 DV list source enter =myname
Pick from list and you get price in B1
Gord Dibben MS Excel MVP
On Tue, 2 Oct 2007 14:23:02 -0700, Steve_Dallas
wrote:
I'm in the AV business and I am creating a room/speaker worksheet where on
Sheet 1, there is a drop down cell for each room that references a list from
Sheet 2 of (1) available speaker types and (2) the added price so that I can
chage it from time to time. Column A would be Classic, Architectual, Extreme,
Yard and column B would be $0, $400, $600, $800 respectively.
The resulting drop down name on Sheet 1 would be a combination of the 2
columns from Sheet 2. For example "Classic ($0)" or "Yard ($800)" with the
parenthesis.
Once 1 of the 4 is chosen, I would like that cell to have the dollar value
that it represents so that after selecting the type of speaker for each room
there will be a total of added expense at the bottom of the form.
Thank you in advance!
|