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

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.

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