John welcome to the forum.
You don't state which version of Monarch you are using. If you are using Monarch V6Pro or newer you can use the External Lookup feature. You can find that on the Table tab under "Data". You can link to either speadsheets or databases with this. It is similar to the VLookup function in Excel.