Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find specific field value in sheet.
I need to build a sphreadsheet, where the user type in 2 values in 2 fields,
(Value "lenght" and value "Width" ). In a sheet where you have a culum "C" with 3 diffent values (100,200,300), and a row "5" with 3 different values, (100,200,300) The point is now that the user type in (or choose from roll down bar ) the lenght, and from another bar choose the Width, then he can see the unique value in a cell called " Price", the unique value is a predefined number( not a calculation ) in the field where the width and lenght meets in the sheet. ( Eks. choose lenght as 100, and withd as 300, then where 100 and 300 meets in the sheet i see the price, this price is transfered to a cell, which i can use for another calculation ( I have 3 other semilar sheets where i will "pick" the unigue value/price, and summarize these as a final price. How do i do ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
We need to add 1 to a specific field on every raffle | Excel Worksheet Functions | |||
empty values for a specific field | Excel Discussion (Misc queries) | |||
Summarizing field quantities for specific records | Excel Worksheet Functions | |||
How do I count a value if another field = a specific value? Excel | Excel Worksheet Functions | |||
How do I select only specific parts of one field? | Excel Worksheet Functions |