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 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


+-------------------------------------------------------------------+
|Filename: example.gif |
|Download: http://www.excelforum.com/attachment.php?postid=3476 |
+-------------------------------------------------------------------+

--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=378233