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

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

ctrl+shift+enter, not just enter


"geebee" wrote:

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

hi. thanks. could you please explain the revised formula so that i can
better understand and interpret it?

thanks in advance,
geebee


"Teethless mama" wrote:

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

ctrl+shift+enter, not just enter


"geebee" wrote:

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