Hi James
> 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
I think VLOOKUP should be a possibility:
=IF(ISERROR(VLOOKUP(C7;expense.C1:C6;1));"";"R")
In this example C7 is the cell in the bank-table which contains the value
"7.55" and the range $C$1:$C$100 is the amount-column of the expense-table.
The range must be absolute, so you have to use the "$" or you could give a
name to the column ((insert/name) and write the formula like this:
=IF(ISERROR(VLOOKUP(C7;amount;1));"";"R")
--
_________________________________________________________________________
Claudia
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
