Creating a Formala
 

Here's my scenerio:

Sheet 1 is the main page with all the information (a quotation with material
and price breakdown). In columns A & B data has to be entered in manually.
Each row in column C is set as drop down menus created by an Item List
created in Sheet 2 (done by Data Validation).

Now, in Sheet 2 where I have all the items listed, in another column I have
listed the price for each item. For example A1=Part Number, B1=Part
Description, C1=Cost of Item.

Is there a way to automatically plug in the price listed on C1 of Sheet 2
onto Sheet 1 when an item is selected from the drop down menu?

Can anybody help??....Please...

=VLOOKUP(C1,Sheet2!A:C,3,0)

For examples on using VLOOKUP, take a look at:

http://www.contextures.com/xlFunctions02.html
http://www.techonthenet.com/excel/formulas/vlookup.htm
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Here's my scenerio:

Sheet 1 is the main page with all the information (a
quotation with material
and price breakdown). In columns A & B data has to be
entered in manually.
Each row in column C is set as drop down menus created
by an Item List
created in Sheet 2 (done by Data Validation).

Now, in Sheet 2 where I have all the items listed, in
another column I have
listed the price for each item. For example A1=Part
Number, B1=Part
Description, C1=Cost of Item.

Is there a way to automatically plug in the price listed
on C1 of Sheet 2
onto Sheet 1 when an item is selected from the drop down
menu?

Can anybody help??....Please...
.

Thank you very much for your help Jason. Exactly what I was looking for.

Jenn


"Jason Morin" wrote:

=VLOOKUP(C1,Sheet2!A:C,3,0)

For examples on using VLOOKUP, take a look at:

http://www.contextures.com/xlFunctions02.html
http://www.techonthenet.com/excel/formulas/vlookup.htm
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
Here's my scenerio:

Sheet 1 is the main page with all the information (a
quotation with material
and price breakdown). In columns A & B data has to be
entered in manually.
Each row in column C is set as drop down menus created
by an Item List
created in Sheet 2 (done by Data Validation).

Now, in Sheet 2 where I have all the items listed, in
another column I have
listed the price for each item. For example A1=Part
Number, B1=Part
Description, C1=Cost of Item.

Is there a way to automatically plug in the price listed
on C1 of Sheet 2
onto Sheet 1 when an item is selected from the drop down
menu?

Can anybody help??....Please...
.