If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




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 ? 
Ads 
#3




How to find specific field value in sheet.
If you are really lucky to have 100,200,300 for both width and length then,
provided this is the layout A B C D E width 100 200 300 length 1 2 3 100 4 5 6 200 7 8 9 300 G H I width length price 200 300 8 =INDEX(B24,H2/100,G2/100) in I2 gives the required price. Regards, Stefi „Anders Bjerregaard” ezt *rta: > 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  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
We need to add 1 to a specific field on every raffle  raffle printing  Excel Worksheet Functions  3  August 31st 09 05:51 PM 
empty values for a specific field  avi  Excel Discussion (Misc queries)  0  December 10th 07 10:09 AM 
Summarizing field quantities for specific records  Charleswdowd  Excel Worksheet Functions  0  June 2nd 06 01:12 AM 
How do I count a value if another field = a specific value? Excel  AprilCarter  Excel Worksheet Functions  3  September 14th 05 03:49 AM 
How do I select only specific parts of one field?  wearfinkle  Excel Worksheet Functions  1  February 21st 05 03:46 PM 