yes this one did finally work.. one more query for you.. H3 is the day of the
week.. eg sunday thru Saturday I'd like to enter the actual date in the cell
next I 3 then have the day of the week pop up in H3 but that spoils the
match formula.. any ideas or advice on how I could accomplish this?

"T. Valko" wrote:

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