I have a workbook with several work sheets. Some worksheets have a project specific table listing materials on order, projected delivery dates, cost, vendor, and purchase order number for that specific project. Not all rows will have a purchase order number. I have a summary worksheet that I want to pull data from the project specific work sheets. I would like the summary table to populate it's rows with the data from the project work sheets, but only the rows that have a PO number. PO number is in the right most column. I do not want the rows without a PO number to be displayed in the summary table.
I have messed around with Vlookup, index match, and a couple other functions but cannot get them to behave the way I would like. Any suggestions for other formulas to try?
summary table headings, starting in column C:
Item / PO Number / Cost / Vendor / Delivery
Project specific table headings starting in column C:
Item / Lead Time / Delivery / Cost/ Ordered / Vendor / PO Number
Bookmarks