Right now, I have a source file that shows several lines of our purchase order (PO). The ‘powers that be’ would like the total of those lines to match the total listed on the summary sheet (which is a separate excel file). Is there a Vlookup formula that can look up items by PO number then post the formula on an excel sheet in a separate workbook? If so, how would you write the formula? Thanks!