Hi ayl322,

Perhaps you need to rewrite your code similar to this. In your code you are
trying to return a value to A1 and your table array is the same column, A.
Also, you are asking to return the value in the second column of the table
array and you only have one column.

Worksheets("sheet1").Range("A1").Value = _
Application.WorksheetFunction. _
VLookup(Range("F1"), Range("B1:C5"), 2, 0)

So here I want to return a value to A1, using the value in F1 as the lookup
value and the table array is B1:C5 and I want the second column using the 2
and an exact match using the 0.

HTH
Regards,
Howard

"ayl322" wrote in
message ...

Hi, I'm having trouble making the vlookup function work in VBA.
the values that are used are all dates, I don't know if that makes a
difference.


Worksheets("sheet1").range("a1").value = application.WorksheetFunction.
_
Vlookup(Range("c1"), range("a:a"), 2)

this gives me a run-time error '1004' Unable to get the vlookup
property of the Worksheet function class


so i tried this:
Worksheets("sheet1").range("a1").value =
application.Vlookup(Range("c1"), _
range("a:a"), 2)

but this gives me a #REF error.

What am I doing wrong?

Any help would be appreciated!


--
ayl322
------------------------------------------------------------------------
ayl322's Profile:
http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=390609