Thank you so much for responding,
I dont think I did a good job of explaining myself. The Insurance Payment Report is a report that is generated from our current billing software. I am wanting to be able to use this spreadsheet to create an invoice that we can provide to our contract therapists showing the same information from Insurance Payment Report that is in columns highlighted in yellow (basically the names of clients that were seen/the DOS/the PCT)....I want to use the data from the yellow "Applied Payments" column to be able to automatically populate a corresponding "Adjusted Amount" that will be paid out to the therapists (This would be the GREEN Column that I added to the "Invoice Wanting" spreadsheet. The third speadsheet is a table of the current amounts that we pay out when we are paid a set amount by insurance....for example when Insurance pays us $47.94 as listed in the "Adjusted Payment " worksheet...we pay the therapist $37....so I would want for this to automatically populate on the "Invoice Wanting" spreadsheet.

If I cut and past the data from "Insurance payment Report" to "Invoice Wanting" my HOPE is that there is some way that the $ amounts listed in column P can somehow reference the "Adjusted Pay Amt" table from 3rd spreadsheet and automatically populate column R with the amount that we need to pay therapist. I would not want the data from Row P (applied payments) to be visible on the "Invoice Wanting" spreadsheet.

I hope this may be a little clearer now?

Thanks!