I changed the formula that I originally posted. One of my VLOOKUP columns was wrong. The formula below should be OK. Sorry!
There was one other condition that you did not specify.
"If everything is in agreement then column F would just stay empty."
However, you didn't say what Column F should show if there wasn't a matching PO#.
The following formula should give you what you asked for, but it will also tell you if a PO# on Sheet A isn't found on Sheet B. Using a blank cell for both "No Error" and "No PO Found" would be confusing, at least to me.
The first thing this formula does is lookup the PO to see if it even exists on Sheet B. If it does, then it checks both the Due Date and the Qty. If either of them don't match, it returns the Due Date from Sheet B.
=IF(ISNA(VLOOKUP(A2,B!$B$6:$B$24,1,0)),"PO Not Found",
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03