Search in close workbook

  • Thread starter Thread starter slideman
  • Start date Start date
S

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 ?:confused:
 
=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
 
Back
Top