Pull in value based on multiple criteria from one table to another

[mish2212]

Hello! I have two tables as following:
Payments

Refer_no	CPT Code	Payment
230192	U002	1.00
230192	89X	2.00
220183	50C	2.50

Charges

Refer_no	CPT Code
230192	U002
230192	89X
220183	50C
220183	9Z1
240522	9Z1

I want to create a calculated column on the charges table which pulls in the "payment" column from the Payments table FOR the matching Refer_no and CPT Code. There is a blank if there is no existing value in the payments table. So result would look as follows:

Charges

Refer_no	CPT Code	Payment
230192	U002	1.00
230192	89X	2.00
220183	50C	2.50
220183	9Z1	BLANK
240522	9Z1	BLANK

I've tried FILTER and Lookupvalue, but it ends up filtering the resulting visual so that only the matches show and the blanks are removed. Please help! Thank you 🙂