hi,

i have the following:

=INDEX(alldata!$E$1:$E$44444,MATCH(C3,alldata!$C$1 :$C$44444,0),MATCH(pivot!$C$6,alldata!$A$1:A$44444 ,0))

but i am getting #REF error. the cells frmo the pivot sheet are actually
coming from a pivot table, and the pivot!$C$6 is a date. im not sure what is
causing the error.

thanks in advance,
geebee