Help with Excel Workbook

[uncledad2002]

I'm trying to develop a workbook to to pull in figures from another section.

Basically I've got various classes of grains and a price per bushel for each of those grains on one worksheet. I want to have another worksheet that you can select (is this a filter?) the grain from in one column and it will automatically pull in the price per bushel from the other worksheet and use that to calculate a total price.

I hope this make sense - I searched the forum, but I really don't know what this process is called.

thanks in advance

Brad

[tkaplan]

Assuming your workbook has 2 sheets:

Sheet1 and sheet2

sheet1:
col A..................colB
Grain1..............1.05
grain2...............0.84
grain3...............1.28

colA
=Sheet1!A1
=Sheet1!A2
=Sheet1!A3

then hide col A (If anyone knows how to do a validation from a list that's not on the same page, please let me know. As far as I know this is not possible, so that's why I'm copying over this list and then hiding it.)

select colB. Go to Data-->Validation.
Allow: List
Source: =$A$1:$A$3
check the box that says "in cell dropdown" then hit ok.

in col C have the number of bushels

in colD:
=VLOOKUP(B1,Sheet1!$A$1:$B$3,2)*C1

this will take the number of bushels which you entered in C1 and multiply that by the price of the grain selected.

hope this helps

[Piranha]

Assuming your workbook has 2 sheets:

Sheet1 and sheet2

sheet1:
col A..................colB
Grain1..............1.05
grain2...............0.84
grain3...............1.28

colA
=Sheet1!A1
=Sheet1!A2
=Sheet1!A3

then hide col A (If anyone knows how to do a validation from a list that's not on the same page, please let me know. As far as I know this is not possible, so that's why I'm copying over this list and then hiding it.)

select colB. Go to Data-->Validation.
Allow: List
Source: =$A$1:$A$3
check the box that says "in cell dropdown" then hit ok.

in col C have the number of bushels

in colD:
=VLOOKUP(B1,Sheet1!$A$1:$B$3,2)*C1

this will take the number of bushels which you entered in C1 and multiply that by the price of the grain selected.

hope this helps

tkaplin,
I have some Data Validation Dropdown's on a different page
than the list by Naming the list and using the name in the
validation instead of the range.
Hope this hepls.
Dave

[uncledad2002]

ok - that worked for me - except now I have a bunch of "#N/A" where there is no value for the grains. I am trying to build this worksheet to be used by several employees and some may have 3 types of grains, some 15... so I need to have several rows available for input. I tried to build an "IF" function to make the result blank if there is nothing input to the drop down list - however that isn't working.

Is there any way I can make column D return a blank if there is not input in the drop down list for that row (column B)?

Thanks

[uncledad2002]

oops - nevermind. it was simple... my bad.