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))