Formula to lookup data and enter it in another WB

J

joec

I have in WB A four cols, (Date,Details,Credits,Debits) which are
constant and rows which are added to every day.
In WB B colA I would like a formula which enters the date and in colC
either Debit or Credit, provided that certain criteria are met. e.g if
the entry under Details (WB A) says Mr Johns then the date of that
entry and the Credit amount would appear in WB B, colA being for the
date and colC for the amount
I hope this makes sense and that someone can help.
Regards
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top