Vlookup Error

[Dave]

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)

 

[Mike H]

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