Hi.. need help to figure out how to:

two worksheets in same book.. one sheet has list for drop down menu the
other has an invoice.. on the invoice I need cell I 13 which is to be a route
# to reference E 11 (which has name chosen from a drop down list) and then
match the day of the week from the date cell H3.. and return the route
number from either an exact match from list on other sheet or allow me to
choose from a second drop down list eliminating the need to match the date in
above scenario.. hope this makes sense and someone can help.. am new to this
stuff