Associating a Name with a Number
 

I have a drop down list of products in an invoice that I use. When I select
a product I would like the cost of that product to automatically enter in a
different cell. In other words how do I associate a value with a name and
create a formula for it?

Associating a Name with a Number
 

See this great site for instructions and an example:
http://www.contextures.com/xlOrderForm01.html

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Vbgooroo" wrote in message
...
I have a drop down list of products in an invoice that I use. When I
select
a product I would like the cost of that product to automatically enter in
a
different cell. In other words how do I associate a value with a name and
create a formula for it?

Associating a Name with a Number
 

The webside provided by Ron is very helpful, however if you need directions
on how to do it just post back, I'll give you a hand.

"Vbgooroo" wrote:

I have a drop down list of products in an invoice that I use. When I select
a product I would like the cost of that product to automatically enter in a
different cell. In other words how do I associate a value with a name and
create a formula for it?

Associating a Name with a Number
 

I am posting back...please help.

"FC" wrote:

The webside provided by Ron is very helpful, however if you need directions
on how to do it just post back, I'll give you a hand.

"Vbgooroo" wrote:

I have a drop down list of products in an invoice that I use. When I select
a product I would like the cost of that product to automatically enter in a
different cell. In other words how do I associate a value with a name and
create a formula for it?

Associating a Name with a Number
 

To get help that is specific to your situation,
you'll need to let us know what you're dealing with:

Post a typical example.
Let us know what have you tried that isn't working.

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Vbgooroo" wrote in message
...
I am posting back...please help.

"FC" wrote:

The webside provided by Ron is very helpful, however if you need
directions
on how to do it just post back, I'll give you a hand.

"Vbgooroo" wrote:

I have a drop down list of products in an invoice that I use. When I
select
a product I would like the cost of that product to automatically enter
in a
different cell. In other words how do I associate a value with a name
and
create a formula for it?

Associating a Name with a Number
 

Sorry for the delate, I had to go.
Here is as promised.
Lets say your dropdown list is in A, when you select an item in that dropdown
list you want the price to appear in B for that specific item. No I'm not
psycho, I analized your question. Follow this directions as is :
You need SHEET 1 and SHEET 2
1- creating data validation
in sheet 2 in A write all the products
in sheet 2 in B write all the prices you have accordinly to the product.
select all the products in A and name them ( at the top left ) writing
PRODUCTS. You just named column A in sheet 2 (do not select or leave
empty cells)
Go to sheet 1 and select A1.
Click on DATA (at the top menu) validation.
in allow select LIST
in source write =PRODUCTS
click OK.
We did DV or data validation. Now the VLOOKUP.
2-creating the vlookup or giving you the formula you asked for.
In sheet 1 on B1 write this formula as is :
=IF(ISNA(VLOOKUP(A1,SHEET2!A:B,2,FALSE)),"",VLOOKU P(A1,SHEET2!A:B,2,FALSE)).
Everytime you select a product in the dropdown in A1 the price is going to
appear in B1 as you change it and accordinly to SHEET 2 already set up.
Enjoy it and find out for me where was founded the first university in the
new world (call America by Columbus).

"Ron Coderre" wrote:

To get help that is specific to your situation,
you'll need to let us know what you're dealing with:

Post a typical example.
Let us know what have you tried that isn't working.

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Vbgooroo" wrote in message
...
I am posting back...please help.

"FC" wrote:

The webside provided by Ron is very helpful, however if you need
directions
on how to do it just post back, I'll give you a hand.

"Vbgooroo" wrote:

I have a drop down list of products in an invoice that I use. When I
select
a product I would like the cost of that product to automatically enter
in a
different cell. In other words how do I associate a value with a name
and
create a formula for it?