Re: [libreoffice-users] VLOOKUP for Numbers

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: users+help@global.libreoffice.org
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