I am trying to have the cell show the most recent data appear based on other cells.

So in column Q on the detail tracking tab, I want it to search column A for "SPO", if it contains that verbage, then to enter the PO# in column C and the vendor name from column F in column R.

In column S, I want it to look for all matching PO#'s in column C and sum there totals in column K and enter that number in S.

Each PO should only be listed once but the balance should constantly update.

I put an example in row 2.
Perkins Budget Tracking.xlsm