Forum Discussion
Excel Table Fourmulas Question
I am developing a worksheet template for my group. The user will copy some data from our ERP and paste into a worksheet that has a table and some formulas. The formulas all reference the column nam...
If the column names are the same you could use XLOOKUP (or INDEX/MATCH) to select the column by header name. In general it's better to have concrete sample - what is input and which formulae you use for output.
Another point, instead of copy/paste from ERP perhaps Power Query could work to pickup the data.
- Thanks for your help. I'm trying to avoid using index and match, but maybe I can work something in that way without too much trouble.
If you share sample file with desired output perhaps it could be another suggestion. But again, Power Query from ERP could be the solution.
