how can i use range of another excel file

[debashis]

HI
Me, Debashis

I want to create a vlookup in, say file, book1
But refarences will come from, say, book2

how will I create it


plzzzzzzzzzzzzzzzzz
help me out

 

[Ron de Bruin]

Your formula looks like this

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