Kathy,

If Thursday is in cell E1, it won't be found since your match is only
looking through column D. Try this instead:

=index(sheet2!$A$1:$N$50,match(sheet1!$E$11,index( sheet2!$A$1:$N$50,,1),0),match(sheet1!$H$3,index(s heet2!$A$1:$N$50,1,),0))

HTH,
Bernie
MS Excel MVP

"kathy" wrote in message
...
Was sent this formula by Double Z.. one issue with it... on my sheet 2 my
array is actually A1:N57
to match to the drop down list in E 11 on sheet 2( I am using info From
A1:A57 store names sheet 2) then indexing same to match the date H3
sheet1
so that the info for Route # needed in I 13( Sunday to Saturday stored in
H1:N57 on sheet two)will populate... problem is formula will not correctly
match the selections after I get to entering Thursday in H:3 please help
some
more?

=index(sheet2!$A$1:$D$50,match(sheet1!$E$11,index( sheet2!$A$1:$D$50,,1),0),match(sheet1!$H$3,index(s heet2!$A$1:$D$50,1,),0))