LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BEEJAY
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where is the bug in my array? Gail Gurman Excel Discussion (Misc queries) 1 January 25th 05 12:36 AM
Array Manipulation [email protected] Excel Worksheet Functions 4 December 25th 04 09:15 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data Dennis Excel Discussion (Misc queries) 4 November 28th 04 10:20 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"