Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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 ?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default 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(B2:D4,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 ?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 11: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 04:46 PM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"