Q:
Problems using VLOOKUP
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.
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.
ASKED:
Mar 25 2009 2:56 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
As I understood you are using vlookup of finding certain value which appears multiple times in the lookup range. Vlookup is limited to find only single value from the list. That is limition of vlookup. Also, I would try and provide you further assistance if send me sheet or if we have an option to attach MS excel file here. Also, you can try using VBA code.
Regards,
Sarfaraz Ahmed
MS Excel help
