|
|
#1
05-28-2016, 02:45 AM
|
|||
|
|||
Looking up piles in a table depending on soil capacity
=IF(D14='geo capacity'!A1,VLOOKUP(D15,'geo capacity'!A1
 1050,2,IF(D14='geo capacity'!K1,VLOOKUP(D15,'geo capacity'!K2:O1050,2,IF(D14='geo capacity'!F1,VLOOKUP('geo capacity'!F2:H1050,2,FALSE))))))What I am trying to do is look up piles in a table depending on the geotechnical capacity of the soil. The above formula only returns a product if the code in D14 is the first look up in the table. If not it returns false. What I want to do is insert the soil code and then be able to look up the piles with the corresponding soil code in the table. The table consists of 3 soil types in each of cells A1, F1 and K1 with the appropriate piles listed under each soil type. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 from text to table, with conditions depending on format
|
Marco | Word VBA | 2 | 10-29-2015 06:40 PM |
| Project 2013 - resource capacity column | and | Project | 3 | 02-11-2015 07:10 AM |
|
MS Project Resource Capacity and Auto-levelling
|
Senor_Babs | Project | 2 | 11-01-2014 02:46 PM |
|
How to create a table with a number of line depending a number entered by user
|
Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
| Limit of Outlook strage capacity encountered! | ARiley | Outlook | 1 | 09-09-2012 06:52 PM |
Windows XP 
Office 2016
Threaded Mode