Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an array which has 26 pipe diameter sizes in column A ( from A203 to
A228.) It has 17 pipe thickness across Row 202 ( from B202 to R202). At the intersections of the array are the pre-determined welding hours to suit the particular pipe size / pipe thickness. Toward the top of the spreadsheet, I am using 2 data validation lists in adjacent cells B3 and C3 where I select the pipe size (B3) and select the pipe thickness (C3). I need a formula to enter into cell D3 which will display the resultant welding hours from the array below, based on the size and thickness that are selected at B3 and C3. Any help would be appreciated. GrantW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup array | Excel Worksheet Functions | |||
Lookup an array | Excel Discussion (Misc queries) | |||
Lookup "greater than or equal to" in lookup array | New Users to Excel | |||
IF ARRAY LOOKUP ??? Help Please | Excel Worksheet Functions | |||
How do I use <= in a lookup array? | Excel Discussion (Misc queries) |