Price Lists

I built an estimate spreadsheet, I want to be able to choose a product
from a dropdown that I created and have a price automatically come up
for that product in a different cell. Can anyone help?

It sounds like you could build a table with the part numbers in column A and the
prices in column B.

Then you could use data|validation for the dropdown and =vlookup() to retrieve
the price.

Debra Dalgleish has some notes for you:
http://www.contextures.com/xlDataVal01.html
and
http://www.contextures.com/xlFunctions02.html


Musky wrote:
>
> I built an estimate spreadsheet, I want to be able to choose a product
> from a dropdown that I created and have a price automatically come up
> for that product in a different cell. Can anyone help?

--

Dave Peterson

http://cjoint.com/?fbrFQwbdjf

G H
1 Product Price
2 Computer 300
3 Keyboard 15
4 Screen 100

B2:Data/Validate/Liste =$G$2:$G$8
C2:=Vlookup(B2;G2:H8;2;false)

http://cjoint.com/?fbrJUm38Gq
http://www.excelabo.net/moteurs/comp...-listescascade
http://www.excelabo.net/moteurs/comp...svalidationvba

Cordialy JB