Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.
=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. At times we need the ability to bring a value from GP into excel, primarily because it could change or to verify if a key is valid. This is a very simple way to provide the much-needed functionality …
This is an interesting post from Titanium GP. It’s code to create a custom function to make it easier to pull data from GP into Excel.
=GetGP(), the Excel Function that gets data from Dynamics GP database into your spreadsheet, one cell at a time. – ERP Software Blog