B
Bklynhyc
Hi,
I would like to know how to go about formulate a formula to lookup info.
with three of this statement and data list.
they all have
Date , Amount, and merchant no. I hard part is that the bank date are late
and there is a fee on the credit card that would link the bank statement and
the accounting data.
it look something like the following;
Bank statement:
amex 06/17/09 590.00
mc/v 06/18/09 490.00
credit card statement:
amex 06/16/09 600.00
amex 06/16/09 -10.00
amex 06/16/09 590.00
---
mc/v 06/17/09 500.00
mc/v 06/17/09 -10.00
mc/v 06/17/09 490.00
accounting data
amex 06/16/09 600.00
mc/v 06/17/09 500.00
best regards
I would like to know how to go about formulate a formula to lookup info.
with three of this statement and data list.
they all have
Date , Amount, and merchant no. I hard part is that the bank date are late
and there is a fee on the credit card that would link the bank statement and
the accounting data.
it look something like the following;
Bank statement:
amex 06/17/09 590.00
mc/v 06/18/09 490.00
credit card statement:
amex 06/16/09 600.00
amex 06/16/09 -10.00
amex 06/16/09 590.00
---
mc/v 06/17/09 500.00
mc/v 06/17/09 -10.00
mc/v 06/17/09 490.00
accounting data
amex 06/16/09 600.00
mc/v 06/17/09 500.00
best regards