Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Must be overlooking something simple in the help files.
Have two variable criterea: D2 = Length and D4 = Opening Size Chart, as follows: AG96:AL113 Roof Opng 0 30 36 42 48 51 Matl Size 0 60 60 60 90 90 Lengths 14 77.85 77.85 77.85 116.78 116.78 16 85.65 85.65 85.65 128.48 128.48 18 101.20 101.20 101.20 151.80 151.80 20 116.75 116.75 116.75 175.13 175.13 22 124.55 124.55 124.55 186.83 186.83 24 140.10 140.10 140.10 210.15 210.15 26 147.90 147.90 147.90 221.85 221.85 28 163.45 163.45 163.45 245.18 245.18 30 171.25 171.25 171.25 256.88 256.88 32 179.05 179.05 179.05 268.58 268.58 34 202.35 202.35 202.35 303.53 303.53 36 210.15 210.15 210.15 315.23 315.23 38 217.95 217.95 217.95 326.93 326.93 40 225.75 225.75 225.75 338.63 338.63 42 249.05 249.05 249.05 373.58 373.58 44 256.85 256.85 256.85 385.28 385.28 I have ONE cell where I need the $'s to be displayed, based on the variables selected. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Array Manipulation | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |