Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i select data based on two inputs in excel
Try this:
With Your data table on Sheet2, Cells A3:H26 .....B3:=90, C3:95, etc .....A4:=60, A5:=70, etc On Sheet1 C8: 70 C9: 100 C10: =VLOOKUP(C8,Sheet2!$A$3:$H$26,MATCH(C9,Sheet2!$A$3 :$H$3,0),1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bluebell" wrote: 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) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i select data based on two inputs in excel
Bluebell wrote:
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) I made a small example based on OFFSET and MATCH function. You can download from: http://rapidshare.de/files/31086614/...ature.xls.html The formula I used is: =OFFSET(Sheet2!A2,MATCH(Sheet1!C8,Sheet2!$A$2:$A$2 6,0)-1,MATCH(Sheet1!C9,Sheet2!$A$2:$H$2,0)-1) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i select data based on two inputs in excel
A couple comments about my post:
I eliminated the blank row under the Inlet Temperatures I changed the 280 at the bottom of the left column to simply 280 *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Try this: With Your data table on Sheet2, Cells A3:H26 ....B3:=90, C3:95, etc ....A4:=60, A5:=70, etc On Sheet1 C8: 70 C9: 100 C10: =VLOOKUP(C8,Sheet2!$A$3:$H$26,MATCH(C9,Sheet2!$A$3 :$H$3,0),1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bluebell" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help creating invoice in excel based on data and | Excel Discussion (Misc queries) | |||
Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
How do I select on two variables in a range of data in excel | Excel Worksheet Functions | |||
Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) |