Im just setting up a spreadsheet for structural timber design calculations. One of the requirements for this spreadsheet
is to look up a Zx value from a table. Once the Zx value is found it returns a size of timber from another column. I have
managed to create the function so that it looks up the Zx value and returns the size. However, if the function cant find the
exact Zx value, which will usually be the case. The next lowest Zx value is used. Is there a way i can edit this function so
that it returns the next highest Zx value instead of the next lowest.
At the moment this is the code i am
=LOOKUP(Q92, 'Zxx Table'!E5:E172,'Zxx Table'!C5:C172)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Q92 is the value to be looked up
E5:E172 is the column of values to be searched
C5:C172 is the column of values where the result comes from
In addition to this just to further complicate
things, can it return say the next 5 highest values?
If a lookup function cant be used could you tell me another
way that i can achieve this.
Im sorry if this is not too clear, if you need further information let me know.