OK. Take two. Since VLOOKUP for numbers with an inequality is not
meaningful, what I precisely hope to do is this. I hope that the
preformatted columns survive the mailer software.
Give the following columns:
A B C D
--- --- --- ---
1.1 eqn 3 0.10
1.3 6 0.12
1.5 10 0.15
1.7 18 0.18
2 30 0.21
2.2 50 0.25
2.7 80 0.30
3.2 120 0.35
3.7 180 0.40
4.3
4.8
5.3
6.4
7.4
8.4
Compare cells in column A such that:
0 > A1 <= C1
C1 > A1 <= C2
C2 > A1 <= C3
...
is true. Then return the value of D for the appropriate row. Repeat for
all values of A. When done, the length of column B will be equal to the
length of column A. B will contain values of column D. Both C and A will
always be sorted. (Although it would be nice to be able to do this with
A being random numbers.)
It seems like I need an array equation, but the array A is not equal in
size to the array in C. Simple string matching of VLOOKUP is inadequate
to the task at hand.
Thanks in advance,
Jason C. Wells
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
