I try to get the vlookup results to a variable via a vba macro
however, the table of data is in book2 and my macro and active sheet is in
book1. Both books are on the same directory
I use excel2000 and windows xp and it does not work
the specific line of the vba is:
VLUV = application.worsheetfunction.vlookpu(27,book2!rang e("a1:g12"),3,false)

actually I'd rather like to use book2!table01 instead of the range function
but
none of this two ways work

please help