Dean Thatcher
New Member
Iam trying to use =INDEX(Appt_date,$M9) in this file. this is the list of the searches. the "Appt date" do not have any effect on any searches.
Customer#, Cust name, >= Appt date1, <= Appt date2, Appt time, Venue, Coordinator, Assistant
here is a example of a search
changing the Appt date does not change to results.
I would like to add 3 more searches items to the list and show results.
want to add Col8, col9, and col10.
Customer#, Cust name, >= Appt date1, <= Appt date2, Appt time, Venue, Coordinator, Assistant
here is a example of a search
SEARCH | Search Boxes | Search results | ||||||||
Customer# | Row | Customer# | Cust name | Appt date | Appt time | Venue | Coordinator | Assistant | ||
Cust name | 1 | 1 | Taylor | 6/1/2009 | 8:00 | - | Robinson | Lee | ||
>= Appt date1 | 5/5/2005 | 4 | 4 | Jackson | 6/1/2009 | 11:00 | - | Robinson | Lee | |
<= Appt date2 | 6/6/2006 | 10 | 10 | Martinez | 6/2/2009 | 13:00 | - | Robinson | Lee | |
Appt time | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | ||
Venue | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | ||
Coordinator | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | ||
Assistant | lee | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! | #NUM! |
I would like to add 3 more searches items to the list and show results.
want to add Col8, col9, and col10.