Associating a Name with a Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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).
 
Back
Top