Try this:

=INDEX(Sheet2!$A$1:$N$57,MATCH(Sheet1!$E$11,Sheet2 !$A$1:$A$57,0),MATCH(Sheet1!$H$3,Sheet2!$A$1:$N$1, 0))

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