vlookup issue

I'm trying to use vlookup on two sets of data where my lookup value is in column "A" of the first data set below. My table array is column "A" through "C" in the second data set below, where column index number = 3, which is column "C", the "date" column in the second data set. When I run this vlookup I get the result in column "C", the "Scheduled appt" column in the first data set, which is incorrect. My return is a duplication of the column "C" data of the first row of the second data set "8/19/2010".

What I need is the return to give me each of the two dates from the second data set as in the third data set below which I have faked so you can see what I'm trying to accomplish.

Any help would be GREATLY appreciated as I'm at my wits end on trying to find a solution for this. I'm still too new to figure this one out by myself.

My actual data sets contain over 50 thousand records, some of which will have, as in the examples below, clients with multiple records, of which I need to return each individual date from the second data set that relates to the "ActRecordid" of the first data set.
A B C D
ActRecordid ActionCode Result scheduled appt
019P91KITX INCALL*** APPOINT** 8/19/2010
019P91KITX INCALL*** APPOINT** 8/19/2010
-------------------------------------------------------------------------------------------------------------------
A B C D
recordid act_code Date result_code
019P91KITX APPOINT** 8/19/2010 0:00 SHOWNOSALE
019P91KITX APPOINT** 8/17/2010 0:00 CANCEL***
---------------------------------------------------------------------------------------------------------------------
A B C D
ActRecordid ActionCode Result scheduled appt
019P91KITX INCALL APPOINT 8/19/2010
019P91KITX INCALL APPOINT 8/17/2010

Thank you for your help!
Anthony

*

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

firstly the syntax of your vlookup is wrong
=VLOOKUP($A$3:$A$11,'lookup data set'!$A$2:$C$10,3,FALSE)
the first bit should be thing to lookup it cant be a range $A$3:$A$11
i've reproduced the results you wanted see helpers in yellow

fyi the vlookup should just be
VLOOKUP(A3,'lookup data set'!$A$2:$C$10,3,FALSE)
dragged down will change to
VLOOKUP(A4,'lookup data set'!$A$2:$C$10,3,FALSE)
from help files

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

and as you have found out vlookup always returns the first value only that meet the criteria

just autofil it down