LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how do i select data based on two inputs in excel

Pressure
Psig Inlet Temperature
90 95 100 105 110 115 120

60 1.156 1.289 1.451 1.643 1.915 2.296 2.793
70 1.022 1.140 1.283 1.453 1.694 2.030 2.470
80 0.929 1.039 1.166 1.320 1.539 1.844 2.244
90 0.855 0.954 1.074 1.216 1.417 1.699 2.067
100 0.797 0.888 1.000 1.132 1.320 1.582 1.925
110 0.742 0.828 0.932 1.055 1.230 1.474 1.793
120 0.700 0.775 0.872 0.987 1.151 1.379 1.678
130 0.700 0.737 0.829 0.939 1.095 1.312 1.596
140 0.700 0.707 0.796 1.901 1.047 1.255 1.527
150 0.700 0.700 0.768 0.870 1.012 1.213 1.476
160 0.700 0.700 0.742 0.841 0.979 1.174 1.428
170 0.700 0.700 0.717 0.812 0.947 1.135 1.380
180 0.700 0.700 0.700 0.784 0.913 1.095 1.332
190 0.700 0.700 0.700 0.755 0.880 1.055 1.283
200 0.700 0.700 0.700 0.728 0.849 1.018 1.238
210 0.700 0.700 0.700 0.704 0.820 0.983 1.196
220 0.700 0.700 0.700 0.700 0.796 0.955 1.161
230 0.700 0.700 0.700 0.700 0.772 0.925 1.126
240 0.700 0.700 0.700 0.700 0.750 0.899 1.094
250 0.700 0.700 0.700 0.700 0.728 0.873 1.062
260 0.700 0.700 0.700 0.700 0.709 0.849 1.033
270 0.700 0.700 0.700 0.700 0.700 0.825 1.004
280 0.700 0.700 0.700 0.700 0.700 0.802 0.976


I need to be able to retrieve the corresponding data based on two input
values, the results and input values are in one worksheet (1) and the data
(as above) in another(2). For example : i need to find the corresponding
value for a pressure of 70psig at a temperature of 100oF. The result should
be 1.283.
This result should be based on inputs in two cells(C8(pressure) &
C9(temperature) in worksheet 1)
 
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
help creating invoice in excel based on data and [email protected] Excel Discussion (Misc queries) 1 August 22nd 06 10:47 AM
Select cell from range based on input in excel xp dingy101 Excel Discussion (Misc queries) 3 November 20th 05 12:05 AM
How do I select on two variables in a range of data in excel Jeff Excel Worksheet Functions 7 September 13th 05 01:10 AM
Dynamically create worksheets in Excel based off existing data? tlozier Excel Discussion (Misc queries) 1 September 10th 05 12:25 AM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM


All times are GMT +1. The time now is 11:47 AM.

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

About Us

"It's about Microsoft Excel"