Calling all workbook gurus. Trying to create a workbook that can merge our transaction lines (POs) with vendor prices setup on the item. I can get it to work, but data is missing. When I add criteria to ensure that the vendor price on the PO Line matches the vendor on the PO (to ensure I don't get duplicate records for each PO line if more than one vendor cost is setup) I then loose visibility into the PO lines that don't have a related vendor cost setup. Any insight now to change the workbook criteria (or other ideas) to make the PO Line left join to the vendor price instead of inner join?