Greetings
I been working to solve a rather tricky problem, I was very lucky to find your forum, you have lots of interesting topics.
Anyway back to my question/problem, I've really hit a brick wall here.
I’m using three different excel sheets/files to gather some information.
The data in these files are on the same level of detail dimension wise.
What I now want to do is have a sheet or an excel file that looks up aggregates the figures in the other three excel files/sheets. I’m not sure at all what or if there is any function to help me do this. I know how to use vlookup but vlookup doesn’t aggregate the data. Also Pivotable is something I don’t want to use either due to that I want to read from all three sheets and that the pivot uses somewhat restricted formatting.
See my sketch below to visualize the files. Its just an example of what the file could contain. ^^
I been working to solve a rather tricky problem, I was very lucky to find your forum, you have lots of interesting topics.
Anyway back to my question/problem, I've really hit a brick wall here.
I’m using three different excel sheets/files to gather some information.
The data in these files are on the same level of detail dimension wise.
What I now want to do is have a sheet or an excel file that looks up aggregates the figures in the other three excel files/sheets. I’m not sure at all what or if there is any function to help me do this. I know how to use vlookup but vlookup doesn’t aggregate the data. Also Pivotable is something I don’t want to use either due to that I want to read from all three sheets and that the pivot uses somewhat restricted formatting.
See my sketch below to visualize the files. Its just an example of what the file could contain. ^^