INDEX error

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

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
 
hi. thanks. could you please explain the revised formula so that i can
better understand and interpret it?

thanks in advance,
geebee
 
Back
Top