Re: [libreoffice-users] Re: vlookup is hard to use

thanks a lot,It works for me,I never know it before:)

2010/12/13 Andy Brown <andy@the-martin-byrd.net>

> On Sun Dec 12 2010 18:49:01 GMT-0800 (PST)  henry cui wrote:
>
> > thanks for your answer.:)
> > I tried your method ,but still face two problems
> > 1. I found the second parameter array can't be in other separably xls
> > file.It works just in single file with different sheet.
> > 2. I settle the formulation on the cell,when I drag the cell to extend the
> > formulation to other cells.I found the number of the cell in the
> > function of vlookup is changing.This effect will affect the search scope
> > of
> > the sormulation and it's different from the same rule in the excel.
> > Trying to use mouse to drag formulation become a hard way to handle the
> > formuation,is there any other way to handle this kind of operate
> > that use a single formulation in whole row or column?
> Use the $ to lock to a direct cell number.  A1 will change with either row
> or column as it is dragged.  $A$1 will keep the same no matter where it is
> dragged.  A1 is an indirect reference and $A$1 is a direct reference.
>
> HTH
>
>
> --
> Unsubscribe instructions: E-mail to users+help@libreoffice.org<users%2Bhelp@libreoffice.org>
> List archive: http://www.libreoffice.org/lists/users/
> *** All posts to this list are publicly archived for eternity ***



-- 
best,
henry cui

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***