I am trying to use formulae to check that the order number (sheet A, cell B4) and week due (sheet A, cell Q4 as YYWW) values are found in the same row of sheet B. The order numbers are stored in column E of sheet B, the due date is stored in column O of sheet B as WW.

Note the order number will only have 1 due date on sheet A but multiple due dates on sheet B

I am using match to find the given values on Sheet B:

To check the order number :

Code:

`1 =MATCH(B4,SheetB"E:E",0)`

To check the due date:

Code:

`2 =MATCH(RIGHT(Q4,2)+0,SheetB”O:O”,0)`

When I use

Code:

`=IF(1=2,”Scheduled”,”Needs scheduling”)`

When I use

Code:

`=IF(AND(1,2), ”Scheduled”,”Needs scheduling”)`

I think I'm on the right path but can anyone offer guidance as to my next step(s) to get the formula to keep looking until the the rows to match?

Thank you

Paul