Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Vlookup with validation | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |