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

Hi Ian

I think a VLookup function might help. But I'm not sure I understood your
problem. Can you post a link to an example file?

Cheers,
Pedro


Ian Whitfield wrote
> Hi All
>
> I have a spread sheet in LO 3.4.3 where I record and analyse monthly 
> numbers and amounts for a electricity bill.
> The figures for each month are all in one Row.
>
> Below this I have "Allocation Blocks" that allocate the top figures to 
> different sub-users.
> Like this...
>
>        A     B    C     D
> 1   Jan   00   00   00  ........etc
> 2   Fed   00   00   00  ........etc
> 3   Mar   00   00   00  ........etc
> 4   Apr   00   00   00  .........etc
>
> _ANALYSIS FOR (Month)_
>
> Name - Cell n + Cell n   (where the 'n' has to be the correct Month Row)
> Name - Cell n + Cell n   (ie it increments by one for each month)
> etc
>
> I have simplified the above but this is the basic concept.
>
> How can I modify the formula to pick-up the correct Row for the month I 
> wish to do the analysis - and printout the report for? Is there a way to 
> pick-up the 'Month' in the Analysis Block and use this to select the 
> correct row?
> (In Basic this would have been "If 'Month'=Jan then Row=1" etc etc
>
> Hope you follow me. Thanks for any help.
>
> Ian Whitfield.


--
View this message in context: 
http://nabble.documentfoundation.org/Identifying-the-correct-row-in-Spreadsheet-formulas-tp3573062p3573062.html
Sent from the Users mailing list archive at Nabble.com.

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