I have two workbooks. On the Purchase Orders Tab of the attached "chandoo base workbook" (referred to as W1) I need to place data from the PO's tab of the attached "chandoo get from workbook" (referred to as W2) in the following manner:
1. W1, Purchase Orders!A2:D2 & also F2 the information from W2, PO's!B2:E2 & also G2 IF the value in W2, PO's!B2 exists in W1, Purchase Orders!A2:A1000;
2. IF the value from W2, PO's!B2 DOES NOT exist in W1, Purchase Orders!A2:A1000, then look in W2, PO's!B3 and all the way down;
3. If the value from W2 PO's!B2:1000 does not exist in W1, Purchase Orders!A2:A1000, it should return blanks.
3. I need to copy this formula all the way down the page. Any suggestions?
1. W1, Purchase Orders!A2:D2 & also F2 the information from W2, PO's!B2:E2 & also G2 IF the value in W2, PO's!B2 exists in W1, Purchase Orders!A2:A1000;
2. IF the value from W2, PO's!B2 DOES NOT exist in W1, Purchase Orders!A2:A1000, then look in W2, PO's!B3 and all the way down;
3. If the value from W2 PO's!B2:1000 does not exist in W1, Purchase Orders!A2:A1000, it should return blanks.
3. I need to copy this formula all the way down the page. Any suggestions?