Running a specified function depending on selection in a list.

[Kuade]

Hi,

I'm trying to do the following:

Use a separate worksheet in the same spreadsheet file to act as a variables page to store data that functions source information from. ie. Column A contains "Products" Column B contains the "Price" of that product.

In the main spreadsheet I have 3 columns; A (Product) is a Validation list from Column A on the variables page which shows a dropdown list of all the products, Column B is for the user to enter Quantity, Column C I want it to automatically calculate the Cost by determining the Product that was chosen in column A, multiplying it by the "Price" (which it will get from the relevant field on the variables worksheet) with the user specified Quantity on the main spreadsheet page.

Can someone tell me how I can go about doing this? I've been trawling the help and internet to work it out. Any help would be appreciated.

Thanks.

[Dav]

if you have a list of the products and their price

in c2 try

=b2*vlookup(a2,seperateworksheet!a2:b300,2,false)

You will have to refer to the sheet by the name you have called it

Regards

Dav

[Kuade]

Thats great. Thanks for your help Dav.

[davesexcel]

Here is an example, column A is the data column C is the list to compare with the data