Re: Fwd: Re: [libreoffice-users] VLOOKUP for Numbers

[Dave Liesse]

I agree that the original question is a little confusing.  What 
everybody seems to have forgotten in their replies, though, is that if 
the lookup list is sorted then a non-match will be treated as if it 
matched the next lower value (for example, looking up 6 in a list of odd 
numbers will return the value from the row containing 5).  If you need 
to know that this is not an exact match, the value in that row can be 
compared to the search value.

--
For unsubscribe instructions e-mail to: users+h...@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