Problems using VLOOKUP in Excel 2003 spreadsheet

5 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
microsoft excel functions
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.

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

Discuss This Question: 2  Replies

 
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
  • Brijesh
    Hi,

    Try indexing , if what you want to look up is a combination of columns A & B and the result is in column E, for example, then you need INDEX & MATCH. If the cells you want to look up is in G1&G2:
    =INDEX(E1:E100,MATCH(G1&G2,A1:A100&B1:B100,0))
    but this MUST be entered via ctrl+shift+enter, not just enter or check the resource use VLOOKUP & SUM or SUMIF functions in Excel

    Hope this helps.
    10,185 pointsBadges:
    report
  • ToddN2000
    You may not be able to do what you want with a VLOOKUP. You may need a script to further filter your results. Can you post your VLOOKUP code?
    15,605 pointsBadges:
    report

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