Example for using Vlookup within a other closed file

=VLOOKUP(A1,'C:\Data\[a.xls]Sheet1'!$A$1:$B$25,2,FALSE)

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"aducutlas " wrote in message ...
I'm trying to use the Vlookup function to pull data in from one
speadsheet into another.....but I have trouble using the function...Can
anyone assist.


---
Message posted from http://www.ExcelForum.com/