Thread: Vlookup Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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