I meant to add that any such formula is fallible because it will return
"R" if the amount looked up appears anywhere in the "amount" range. So,
if you have two or more bank payments which correspond to one expense,
each will be classified as "R".
If you want to use several conditions, you could look at SUMPRODUCT or a
database function such as DGET.
Terry wrote:
One possibility is IF(ISNUMBER(MATCH(<debit cell>;<expenses amount
column>;0);"R";"")
James Elliott wrote:
<snip>
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.
<snip>
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]
