It’s like usual lookup. but a bit updated.
I can’t find you comparing currency, so I’ve added it in following way:
I don’t know how you set USD and GBP in other table, because ‘EURO’ != ‘EUR’.
also, Single Select returns object
that’s why I check if text value includes property name of it, instead of check by “===”