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.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 25, 2009 2:56 PM
UPDATED:
April 2, 2009 3:16 AM
RELATED QUESTIONS
- Multiple identical relationships in one Access 2007 table
- Creating Automatic Notifications in Access 2007
- Excel function to identify combination of text and numbers
- SAP BW transports best practices/guidelines/standards?
- The data file Mailbox (userid) was not closed properly. This file is being check for problems
Answer Wiki:
Hello
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
<a href="http://findsarfaraz.blogspot.com">MS Excel help</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
