Global variables or records in table that I can retrieve using formula. Something like function "GET_LIST" but without having to link to other record.

Example - I have a table of FX rates for a specific month and I need to use a combination of functions to filter out the correct FX rate, but without having to continually link the FX rate to the record that needs the FX rate calculation.