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?

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?

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?

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" <(E-Mail Removed)> wrote in message
news:77D99960-B7D7-4589-B583-(E-Mail Removed)...
>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?

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)),"",VLOOKUP(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" <(E-Mail Removed)> wrote in message
> news:77D99960-B7D7-4589-B583-(E-Mail Removed)...
> >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?
>
>
>