So that said, any thoughts on how I might go about at least doing an
index/match where the indexed array is dynamic as well as the matched
array (which is in a row vice a column)?

Sorry.., I just don't have enough experience with pivot tables to be much help
to you. Hopefully someone else may chime in...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion