On Wednesday May 02 2007 2:00 pm, Joe Conner wrote: > Calc uses semi-colons rather than commas to separate items. > > Edward A Janes wrote: > > 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]
Copy sent to Edward. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
