Index and Match across two different workbooks

Originally Posted by etaf

=COUNTIF ([Workbook2.xls]Sheet1!$A:$A , A2)

but will not work if workbook is closed
nor will index() work on closed workbooks

you need index.ext (which is a add-in)

Unfortunately I get #VALUE!