Charlie,
???? If you mean the table in the 'adjusted pay amts' sheet then surely that is intended as a lookup table to convert set amounts received from insurers to set amounts payable to contractors ???

famres,

Just to clarify on my previous post. The formula is tho be in O7:O25 of the 'Invoice Wanting' Sheet.

If the row number for each line item in 'Invoice Wanting' will always be same as the row number in 'Insurance payment report' then you need not copy /paste the Grey Applied Payments to Invoice wanted. Just use the formula .....

=LOOKUP(ABS('Insurance Payment report'!O7),'adjusted pay amts'!$B$6:$C$15) in Invoice Wanted O7