I am working with multi-dimensional data storage and want to lookup values in a pivot table. See attachment for basic setup of my table.
I need a way to get the value at (a1->b2->c1@d6)...which would return 41.
Is there a way to do this using pivot tables and vlookup, or do I need to be using other functions? The data schema can be modified if needed.
Thanks,
JC
Bookmarks