Problems using VLOOKUP

5 pts.
Tags:
Excel 2003
Excel functions
Microsoft Excel
VLOOKUP
VLOOKUP function
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.
ASKED: March 25, 2009  2:56 PM
UPDATED: April 2, 2009  3:16 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following