lookup array
 

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.

I don't really se how your table is constructed but if you want the
intersection where
length and opening size meet you can use index and match, an example can be
found here

http://www.contextures.com/xlFunctio...ml#IndexMatch3


Regards,

Peo Sjoblom

"BEEJAY" wrote:

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.

Sorry my chart didn't copy more clearly, but you understood my question anyway.
Tried it out and it works GREAT.
MUCH appreciated!!
BEEJAY

"Peo Sjoblom" wrote:

I don't really se how your table is constructed but if you want the
intersection where
length and opening size meet you can use index and match, an example can be
found here

http://www.contextures.com/xlFunctio...ml#IndexMatch3


Regards,

Peo Sjoblom

"BEEJAY" wrote:

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.