Match with a range

[MATU70]

Hi

I Have this formula =IF(AND(EXACT($J2,$Z2),P2<=2,P2>=1),10,"") that works perfect, now i wish to add a Match formula to it with a range of 1 more and still be a match e.g 2&2=match or 3&2=match but 4&2=not a match.
Can someone show me how i would go about adding this to the above formula.

Thanks

[BadlySpelledBuoy]

Not sure I understand what you mean.... What are 2&2 and 3&2 etc.? What are you looking to match? Maybe a workbook with some sample data would help...

[MATU70]

I have added a sheet with formula in it, i reqiure (adding column B to the formula) as a match formula but with a range of one more. you will see that Cell B1 has 8 and B2 has 7 this is a match because it is in range of B2 by one more. There are only two possible matches, a straight match or a match within a range of one of Cell B2.

[sktneer]

Not sure exactly what you want to achieve, but see if this is what you are trying to achieve.....

Please Login or Register  to view this content.

[MATU70]

That is exactly it

Thank you

[sktneer]

You're welcome.