Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup in VBA
I am using Excell 2000 with Windows 2000 Professional.
I am trying to get the result of a vlookup into a cell by using For I = 2 To numrows Cells(I, "F") = Evaluate("=VLOOKUP(cells(i, "B"),Box_Log,6)") Next I I get a "Compile Error: Expected list separator or )" at the "B". What gives? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup in VBA
I just tested this for one
x = Application.VLookup(Cells(1, "d"), Range("f1:i6"), 2, 0) or For i = 1 To 9 Cells(i, "f") = Application.VLookup(Cells(i, "b"), Range("g1:i6"), 2, 0) Next i "John Pierce" wrote in message om... I am using Excell 2000 with Windows 2000 Professional. I am trying to get the result of a vlookup into a cell by using For I = 2 To numrows Cells(I, "F") = Evaluate("=VLOOKUP(cells(i, "B"),Box_Log,6)") Next I I get a "Compile Error: Expected list separator or )" at the "B". What gives? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup in VBA
Cells(I, "F") = Evaluate("=VLOOKUP(cells(i, "B"),Box_Log,6)")
should be Cells(I, "F") = Evaluate("VLOOKUP(cells(i, ""B""),Box_Log,6)") you have to double up on double quotes contained within a string. But Don gives a better solution by not using evaluate. -- Regards, Tom Ogilvy "John Pierce" wrote in message om... I am using Excell 2000 with Windows 2000 Professional. I am trying to get the result of a vlookup into a cell by using For I = 2 To numrows Cells(I, "F") = Evaluate("=VLOOKUP(cells(i, "B"),Box_Log,6)") Next I I get a "Compile Error: Expected list separator or )" at the "B". What gives? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |