Quote:
Originally Posted by charlesdh
Hi,
The data you have in sheet "Adj" does not correlate with the info you have in the other sheets. Also how do you know in the "Adj" who the data belongs to?
|
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