In a "Cashbook" workbook I and friends have created, in Excel the line "=HOOKUP($L$4,Summary!$R$4:SAC$35,21,False)" acts as follows in the Reconciliation Sheet. $L$4 is the location of the Month to which you wish to tally to Summary is the sheet from which that data is coming $AC$35,21 guides to the cell from which you wish to copy data False is the justification
In endeavouring to convert this workbook to run on openoffice.calc this line does not act in the same way as the Excel prog. Can openoffice.calc do this sction - do I have to write it differently Your assistance would be greatly appreciated. Edward A Janes [EMAIL PROTECTED]
