I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven.
I am utilizing a form, with a drop down list, to find a volunteer and another dropdown list to find the availability of a volunteer on a given date.
My problem is that I am using the "VLOOKUP" function to search, by the date in the Transportation Worksheet, the availability of a volunteer, and the result given is the first entry of that date in the Transportation Worksheet. I tried creating a VLOOKUP formula that searches for both the given date and a particular volunteer, but I am getting error messages.
March 25, 2009 2:56 PM
April 2, 2009 3:16 AM