I have a multi-sheet Calc workbook (OOo version 2.0.3).
One sheet ("Expenses") is a list of expense items;
another sheet is a copy of my bank statement "Bank").What I want to achieve is this: if there is an entry on my "Bank" statement sheet for, say, $7.55; and an identical amount in "Expenses" (ie, also for $7.55); then I want the letter "R" entered into the corresponding cell in the "Reconciled" column of the "Bank" sheet. In other words: if in Expenses we have: DATE DESCRIPTION AMOUNT 10/10/06 Envelopes (from PO) $7.55 then Bank would look like this: DATE DESCRIPTION DEBIT CREDIT RECONCILED 09/10/06 Fuel 55.46 09/10/06 Deposit 126.00 10/10/06 Post Office 7.55 R I have been trying VLOOKUP and information functions without success and would be very much obliged if one of you clever people could point me in the right direction Many thanks, James --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
