Compare range to a row and return value from range

Seeking any help or guidance. Projects will pay amounts listed in table A, on the dates listed in table B. I'm attempting to combine these two tables in format shown in table C. So if the Payment Dat...