Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup Error
Hi,
I am doing a vlookup using vbs and receiving an error with the formula. I believe it may be syntax but not sure. I am using 2007 but it also needs to run with 2003. Any help would be appreciated. workbook = Br 31 December 2009.xls worksheet = 09 December 2009 range = A1:K810 the column that I am looking for matches is in Column K and I am only looking for exact matches =VLookup(3948974,'[Br 31 December 2009.xls]09 December 2009'!$A$1:$K$810, 11, false) -- Thank you Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup Error
Dave,
Try this, works in both E2003 & E2007 myval = Application.VLookup(3948974, Workbooks("Br 31 December 2009.xls").Sheets("09 December 2009").Range("$A$1:$K$810"), 11, False) Mike "Dave" wrote: Hi, I am doing a vlookup using vbs and receiving an error with the formula. I believe it may be syntax but not sure. I am using 2007 but it also needs to run with 2003. Any help would be appreciated. workbook = Br 31 December 2009.xls worksheet = 09 December 2009 range = A1:K810 the column that I am looking for matches is in Column K and I am only looking for exact matches =VLookup(3948974,'[Br 31 December 2009.xls]09 December 2009'!$A$1:$K$810, 11, false) -- Thank you Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup error | Excel Worksheet Functions | |||
vlookup error | Excel Worksheet Functions | |||
#N/A Error with VLOOKUP | Excel Worksheet Functions | |||
Vlookup Error | Excel Programming | |||
VLOOKUP Error N/A | Excel Programming |