Hello everyone,

I am trying to figure out how to execure a Lookup with multiple look up
criterias. This is my formula right now:
"=LOOKUP(A5,JOURNAL!$J:$J,JOURNAL!F:F)" I tried to use the and
function to say "=Lookup(and(A5,A10), ...)" But that errored out. My
goal right now is to have function look in a different sheet and if
there is a cell whose row meets both criteria it puts it on a different
page.
For example:

In Sheet 1 i have 50 rows of entries with the date, check number,
amount, account number, reference number, ... In Sheet 2 i have a
summary of Joe's account and i want to see if he has been paying me on
time. So i want to enter the reference number in cell A5 and in cell
B5 i have a Lookup function to lookup Sheet 1 and the criteria is if
the row has Joe's account number, and Reference number then i want it
to tell me the ammount. And in the next cell i would change the
formula to give me the date.

I hope that made sence. Email me if you have a question about what i'm
tryign to do.

Thank you all for the help.

Sincerely,
Leon