Resolved via an email exchange ..

The array formula was correctly entered and it correctly returned #N/A due
to no match found, but think this was misconstrued as "not working" by the
OP.

Link to sample file returned to the OP :
http://www.savefile.com/files/4538432
File: Index and match functions help needed_Zak_wksht.xls
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--