How do i make a relative reference to another close WB and do an index match function

I want to use a file reference to close workbook and execute index match function to pull certain range of data from closed workbook and copy it to the active workbook(w macro).

-Closed workbook has lots of data

Do you think its possible to use this method ?

Is possible to use this kind of method?
http://www.vbaexpress.com/kb/getarticle.php?kb_id=454

However , i dont want to retrieve all the data from the close workbook.
I want to use an index function .