Hi Rachel,

application.WorksheetFunction.VLookup(workbooks("b ook1").worksheets("sheet1").range("a1"),workbooks( "book2").worksheets("sheet1").range("table01") ,2)

--
Kind regards,

Niek Otten

"Rachel" wrote in message
...
I want to get the vlookup results to a variable, where that table data is
in
book2
and the key search is in book1 somthing like
Vlook = application.worksheet.vlookup(book1!sheet1[a1],
book2!sheet1[table01], 2)
this does not work. Both worbooks are in the same directory, and I use
excel
2000
and windoew xp
thanks rachel