One possibility is IF(ISNUMBER(MATCH(<debit cell>;<expenses amount
column>;0);"R";"")
James Elliott wrote:
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
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
