Formula to pull data based on one cells value

[Dena]

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

[etaf]

which one is the detail tracking tab
how often will SPO appear - just once ?

[Dena]

I attached the wrong file, here is the correct one.

Perkins Budget Tracking.xlsm

[etaf]

you have SPO a couple of times - so how do you know which one to use ?

[Dena]

For it to list the PO it just needs to look for "SPO" not INV - SPO or SPO - CO. but for the running balance it has to look for all of the PO's that match and add them up. Everytime SPO is entered it should have a different SPO #. The PO#'s will never duplicate if the document type is "SPO"

Does that make sense?

[Dena]

How do you get a formula to search column A, if it contains "SPO" then enter whats in column C from the same row in column Q? If it is blank, continue down the list. The SPO's will be throughout the column A but I want it to condense the list in column Q.

then how do I sum column K if column C matches column Q?

[etaf]

i think you are going to need some sort of VBA - so it looks down the list and know if is already used SPO or to put all in separate rows - I dont know VBA and I'm not sure I know how to do that otherwise

[Old4xford]

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

In column Q, use

=IF(ISNUMBER(SEARCH("SPO",A2)),C2,"")

and pull down.

In column R use

 =IF(ISNUMBER(SEARCH("SPO",A2)),F2,"")

and pull down.

I'm still working on the Column S code.