Re: [libreoffice-users] Identifying the correct row in Spreadsheet formulas

El 10/12/11 10:28, Ian Whitfield escribió:
> Thanks to Brian and the others who have now "put me right" and shown me
> the right way to start a new Thread!!!
>
> Regarding the 'Signature' I was going along with what I found in the
> 'TDF/LibreOffice Mailing List Netiquette'...
>
>
> /"Signature/
>
> /Always 'sign' your message with your name and your preferred e-mail
> address. This is especially important because some e-mail and newsreader
> software do not always convey the originator's full e-mail address.
> While you may certainly include your regular mail address in your
> postings, you may wish to give this out only in personal replies, when
> necessary. /
>
> /Use a short signature, including only the essential information. Four
> lines are usually enough to include name, email, telephone number and
> other nicknames, and - if necessary - corporate affiliation. Please
> avoid lengthy legal disclaimers, which are useless in principle and even
> more useless - and disturbing - when posting to a mailing list."
>
> /
>
> If this is in fact wrong I would suggest that it be changed on the
> WebSite!!
>
> So - OK - I will go back to just signing my name and occasionally adding
> my City!!
>
> Thanks all - On the main question I'm still looking for a positive
> answer. So far VLOOKUP is NOT what I want am about to look at HLOOKUP
> and MATCH.
>
> Just thinking........ I wonder if "=A+'Z4' " would work to give me 'A12"
> if I put the value 12 into Z4. Will try.......
>
> NO - That doesn't work!! I tried various combinations.
> The one I thought would work was 'A+(VALUE(Z4))' but no luck.
> Is my syntax out??
>
> Ian Whitfield
> Pretoria./
> /

Maybe

=INDIRECT("A"&VALUE(Z4))

Miguel Ángel.

 * Español - detectado
 * Inglés
 * Español

 * Inglés
 * Español

 <javascript:void(0);> <#>

--
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