Ability to pull pricing data from a table in salesforce into the opportunity

Hi there,

I need to be able to pull values from a table in salesforce into the opportunity when certain fields are filled in. The table will be updated on a monthly basis. Any thoughts?

thanks,