Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
INDEX/MATCH works good on tables with two or three arguments but I haven't
been able to figure out how to use it with four arguments Criteria Roof Angle Roof Zone Wind Area (Sf)Wind Speed Wind Uplift 7 1 10 120 ? 7 2 10 120 ? 7 3 10 120 ? Net Design Wind Pressure, Pnet30 (psf) (Exposure B at h = 30 ft. with I = 1.0 and Kzt = 1.0) Basic Wind Speed V (mph) ID Roof Angle Roof Zone Wind Area 85 90 100 1 7 1 10 -13.0 -14.6 -18.0 2 7 1 20 -12.7 -14.2 -17.5 3 7 1 50 -12.2 -13.7 -16.9 4 7 1 100 -11.9 -13.3 -16.5 5 7 2 10 -21.8 -24.4 -30.2 6 7 2 20 -19.5 -21.8 -27.0 7 7 2 50 -16.4 -18.4 -22.7 8 7 2 100 -14.1 -15.8 -19.5 9 7 3 10 -32.8 -36.8 -45.4 I can get the Roof Angle, Roof Zone, Effective Wind Area, and Wind speed from other work sheets. I get the "Too Many Arguments" message when trying to get the negative uplift numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup with INDEX MATCH formule depending on 2 conditions | Excel Worksheet Functions | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |