LinkBack URL
About LinkBacks
I just can’t get passed nested if statements.
Can anyone help solve my attached problem?
Thanks.
I just can’t get passed nested if statements.
Can anyone help solve my attached problem?
Thanks.
Are you looking to interpolate or find the intersect ?
(ie are the values in M3 & M5 to be exact matches to the header values in the table)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Woops, forgot to sepcify that.
M3 may not be an exact match.
For example, a input into M3 may be "0.22" but would fall into the "D" column.
Input into "M5" will always fall into rows 5 to 11.
Something like this:
Never use Merged Cells in Excel
Thats great!
Thanks guys!
I have tried to mimic the formula in cell R7 supplied by zbor, in R25
But can't seem to nail it
Anyone?
I’m still trying to finish this formula.
Just can’t seem to get over the line,
Can anyone help?
Not entirely sure I follow but perhaps the INDEX element you're looking for is along the lines of:
Please Login or Register to view this content.
Thanks for the help.
That’s allmost it, but it doesn't seem to quite work with land descriptions "2" and "3"
For example if I have a land description of "2" in cell R21 on the attached,
and a soil permeability of "medium" IN R23 - it should return a vale of "0.32" from cell "i25"
Any ideas?
I did not notice that you have an inconsistent number of columns in each sub table... (1) uses 3 columns [D:F], (2) [G:J] and (3) [K:N] both use 4 columns and merged cells (best avoided)
Goes without saying that a consistent layout generally simplifies the calculations.
Let me know if you are going to modify the tables so that they are consistent (advised - and this means removed the merged cells) or you intend to leave as they are.
That fixed it, Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks