Maybe one way:

=IF(OR(A1=0,A1=1),1,IF(A1=2,3,IF(A1=8,5,IF(AND(OR( A1=3,A1=4),A2=2),4,IF(AND(OR(A1=3,A1=4),A2=3),5,"N o
Match")))))

Regards,
Paul

"mCassidy" wrote in message
oups.com...
I have a sheet that has to columns of numbers. I would like to have a
formula that looks at the numbers in both columns (1 row at a time)
and gives me a result in column 3 based on that comparison.

Column A will be one of the following values= 0,1,2,3,4,8
Column B will be one of the following values=2,3,8

Here is my criteria for comparing the two (assuming I am comparing A1
and A2 first, with the result being in A3):

If A1=0 or 1 then A3=1 (no comparison needed on the first 3)
If A1=2 then A3=3
If A1=8 then A3=5
If A1=3 or 4 and A2=2 then A3=4
If A1=3 or 4 and A2=3 then A3=5

I can write out the specifics of what I need to compare.. I just have
no solid idea of how to put that into an Excel formula.

Any help at all is greatly appreciated.

Matt