Quantity Formula's between sheets

[daffyw]

Morning,

I have a formula query which I hope someone may help me with, I have a workbook with multiple sheets, within the workbook for example page PTA is numerous drop down menus and fields (Bit like a configurator). In sheet 1 (different Tab) I have several part numbers which reflect the options with the drop down list held within Page PTA. How do i write the following formula?

Example
If I select a qty on PTA page and a voltage, which ROW G9 & ROW G11
G9 = 2
G11 = 630A

How do I get the formula into sheet 1?

In sheet 1 IS the following:
DV19153 row B2..i Want the quantity filled in if 630A is selected
DV19154 row C2..i Want the quantity filled in if 1250A is selected
DV19155 row D2..i Want the quantity filled in if 2000A is selected

For this example
DV19153 is the 630A option, so I want ROW B2 populated by the quantity I have select, which in this case =2.

Any Ideas?

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[daffyw]

Thanks,

i have enclosed an example workbook, In PTA there is Quantity and voltage (Which is a pull down list) B2 & B3 determine what the answer should be in tab 01...in this case 630A Part number DV19153 = 2.

On tab 01 is where I would like this information filled in, Example Column C.....

Hope this explains a bit better.

[:) Sixthsense :)]

May be this...

In C2 cell of Tab01 sheet

=SUMIF(PTA!$B$3:$E$3,B2,PTA!$B$2:$E$2)

Drag it down...

[sagrok]

you can use the Vlookup function for this,

also clearly mention what you want...

don't confusing........

The experts team should be help you...

Sagrok

[daffyw]

Thank you guys, Works a treat and thanks for the advise for future help Threads........

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep