LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
galv2
 
Posts: n/a
Default Lookup Function and Match

Hey
Im a final yr degree student .
Loading (KN)
4kN 5kN 6kN 7kN
Depth
100 2.5 2.3 2.4 2.5
150 2.9 2.5 2.7 2.8
200 2.6 2.7 2.4 2.2
250 2.7 2.7 2.7 2.7

The Left Hand Column contains the Depth of the Slab Required in mm
The Top Row is The MAX Loading Applied in Kn
The internal values are the distance the slab must span in metres

My problem is that if I were to pick a load value of 6kn over a slab
distance of 2.6m then i would like it to return the corresponding slab depth;
in this case 150mm or 250mm is sufficent. Similarily if i was to choose a
load of 7Kn and a slab span of 2.8m then it would return a depth value of
150mm
 
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
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
I want to use the MATCH function with the AVERAGE function but I . Miguel Excel Worksheet Functions 2 April 23rd 05 05:29 PM
Lookup Function - Specific Values Steve Elliott Excel Worksheet Functions 6 April 9th 05 07:15 PM
Match Function arguments Stan Altshuller Excel Worksheet Functions 3 March 11th 05 08:48 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 02:49 AM


All times are GMT +1. The time now is 11:38 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"