Code/Macro return the value from a statement to a table cell?

Hi

1. Is there a code or macro that will help return the value from a statement for a specific id to a table?

The value will be in a cell on Invoice is - Late Fee and the value will have to be transferred to a table on Invoice Main was under a specific column in this case P8. It needs to match the Invoice # so when you change the invoice # it adds it to that specific one.

Thanks

@than_gold thanks tried that but didn't get it right, I have it posted in the formulas forum with the formula i'm using if you want to check it out