One way is to use a new helper column just to the left of your data table and
CONCATENATE the cells from the two columns of interest into the new
column......then look up the CONCATENATION of the two cells of interest in
this new column and step over to the values you seek. i would use VLOOKUP.

Vaya con Dios,
Chuck, CABGx3



"Leon" wrote:

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