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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!