You can try something like this:

=IF(COUNTIF(A$1:A1,A1)=1,INDEX(Balance,MATCH(A1,PO ,0),"")

Copy down as needed.

--
Biff
Microsoft Excel MVP


wrote in message
...
Hello all,

First I have to say that I've not posted a question in over 5 years
due to the fantastic results I've had searching for solutions in this
group.

I'm developing a Pivot Table to calculate PO balances. The problem
I've having is that a PO number resides in every row in the database.
I'm looking for a solution that will pull the PO amount for the first
instance into a new column and then pull zeros for the remaining
instances. Any assistance with this project is gratefully
appreciated. Thank you in advance, Ron