Search in close workbook

[slideman]

I build database that is based on 3 excel files.
I have main file that is containing the dynmic data, and 2 files that
are const.
I want to search the 2 files for data, Lets say to search a person name
and to get all his details ( Doing vlookup on close files).
How can I do it with VB on close files ?

 

[Ron de Bruin]

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

You can use this to search for the value that is in A1 in
A1:A25 in the closed workbook test1.xls and display the value in the B column