At 21:15 24/03/2013 -0700, Jason C. Wells wrote:

`I haven't had any luck figuring out a method to compare each element
``of a list of numbers to each element of a differently sized list of
``numbers. What I want would do something very much like VLOOKUP, but
``instead of matching strings, it would compare a number ...
`

VLOOKUP() works with numbers as well as with strings.

... using an inequality ...

`If you have an inequality, you are not searching for a match, so I
``suspect VLOOKUP() is not what you need. Surely in this case some of
``your array values will satisfy the inequality and some not? In
``general, half of your list (well, a moiety of it) will satisfy your
``inequality and the rest not. Which of the many rows that satisfy
``your inequality do you wish to reference? Can you not just build a
``formula to achieve what you need?
`

`... and then return a value from another column along the row where
``a match was found.
`

That's also easy with a formula.

Is there a vlookup function for numbers ...

Yes: it's called VLOOKUP().

... with ability to use inequalities to find a match?

I suspect that is not the best way to solve your problem.

`Does this list allow attaching files? A small spreadsheet would
``describe what I want to do much better than words.
`

`Actually, I doubt that this is true. You say you "haven't had any
``luck", so all we know is that whatever you sent would *not* do what
``you wanted; it wouldn't explain what you do want. It's generally
``better to explain carefully exactly what you are trying to do.
`
I trust this helps.
Brian Barker
--
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

### Context

Privacy Policy |

Impressum (Legal Info) |

*Copyright information*: Unless otherwise specified, all text and images
on this website are licensed under the

Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (

MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our

trademark policy.